/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 vote236 views1 answer
Set a value by excuting stored procedure
SQL
0 vote305 views1 answer
ORA-01400
SQL
0 vote211 views1 answer
Dump only schema
SQL
7 votes246 views2 answers
Where keyword sql
SQL
0 vote230 views1 answer
Sql server system messeges
SQL
0 vote227 views1 answer
Mysql multiple group by
SQL
9 votes231 views4 answers
How to create new user and database postgresql in ubuntu
SQL
0 vote227 views1 answer
Get enginge db mysql
SQL
17 votes243 views6 answers
Change column name in sql
SQL
1 vote207 views3 answers
Mysql Server Start
SQL

Share