/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

7 votes258 views3 answers
Sql server check if temp table exists
SQL
0 vote216 views2 answers
Add new column after in sql
SQL
1 vote200 views1 answer
ELECT list is not in GROUP BY clause and contains nonaggregated column 'schogdsw_db.SE.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote200 views1 answer
Windows services sql
SQL
14 votes205 views2 answers
Oracle export trigger ddl
SQL
1 vote197 views6 answers
In sql
SQL
0 vote156 views1 answer
Mysql collation for all languages
SQL
0 vote214 views1 answer
MySQL INSERT IGNORE Statement
SQL
0 vote157 views1 answer
Expose db in virtualbox
SQL
0 vote210 views1 answer
Sql DATE = GETDATE()
SQL

Share