/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

1 vote156 views1 answer
Sometimes i cant edit sql developer
SQL
0 vote146 views1 answer
LoadError: cannot load such file -- mysql2/2.7/mysql2
SQL
0 vote153 views1 answer
Sql server alter table add column datetime default current_timestamp
SQL
5 votes192 views1 answer
Oracle ora-00054 resource busy
SQL
2 votes113 views1 answer
Sql float to int
SQL
1 vote165 views1 answer
Sql count value greater than
SQL
0 vote150 views1 answer
Show size of all tables postgres
SQL
0 vote161 views2 answers
Sql server select first day of previous year
SQL
0 vote153 views1 answer
Mysql drop multiple tables at once
SQL
13 votes312 views4 answers
Sql joining 3 tables
SQL

Share