/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 vote248 views1 answer
Enable mysql slow query log
SQL
0 vote308 views1 answer
Updating database in sql
SQL
3 votes297 views1 answer
Oracle list user grants
SQL
1 vote300 views1 answer
Check current sequence value postgres
SQL
0 vote376 views1 answer
Compare strings lexicographically in sql
SQL
5 votes277 views1 answer
Oracle columns in all_tables
SQL
-1 vote282 views1 answer
Mysql delete duplicate rows except one
SQL
0 vote304 views3 answers
CONTACT FORM SQL
SQL
6 votes269 views1 answer
SQL insert all columns
SQL
1 vote307 views1 answer
Mysql print variable
SQL

Share