/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 vote334 views1 answer
Radius search with point data in mysql
SQL
0 vote336 views4 answers
Rownum in sql
SQL
18 votes331 views4 answers
Uninstall mysql on ubuntu
SQL
0 vote331 views1 answer
Select into table variable
SQL
1 vote321 views3 answers
Postgresql crete view
SQL
2 votes337 views1 answer
Oracle sql merge
SQL
11 votes353 views4 answers
Update row in mysql
SQL
3 votes353 views2 answers
Mysql update row
SQL
2 votes322 views3 answers
How to get second highest salary in each department in sql
SQL
0 vote527 views1 answer
Multiple row join
SQL

Share