/SQL/Postgresql list columns

Postgresql list columns

List columns in table postgres

-- Good for quickly reminding you of what columns exist.
SELECT * FROM mytable WHERE 1=0;

1

Postgresql list columns

SELECT * FROM information_schema.columns 
WHERE table_schema = 'your_schema'
  AND table_name = 'your_table';

0

Similar codes

0 vote125 views1 answer
SQL add a totals of differemt rows of the same id
SQL
4 votes120 views1 answer
Oracle user tables
SQL
0 vote122 views1 answer
Mysql auto increment in YY-MM-XXX format
SQL
0 vote121 views1 answer
Sql select with apostrohpe
SQL
1 vote116 views2 answers
Grab part of a string sql
SQL
0 vote119 views1 answer
FILENAME /usr/bin/mysql does not exists. Make sure correct path is set in /etc/dump admin/settings.conf.
SQL
2 votes113 views1 answer
Oracle current date without time
SQL
6 votes151 views2 answers
Oracle undotbs usage
SQL
5 votes138 views1 answer
How to get all table names in sql query
SQL
0 vote114 views1 answer
Formatting code with SQL Developer
SQL

Share