/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 vote167 views1 answer
Drop function
SQL
0 vote182 views1 answer
Mysql command line top 10
SQL
2 votes183 views1 answer
Oracle convert run_duration to number
SQL
1 vote174 views1 answer
Mysql select if empty result
SQL
0 vote165 views1 answer
How to increase the width of the screen in oracle
SQL
1 vote183 views1 answer
Mysql select row max date
SQL
1 vote192 views1 answer
Rows to comma separated values in mssql
SQL
0 vote171 views1 answer
Select in select sql
SQL
0 vote135 views1 answer
Provera dupliranih konatakata
SQL
4 votes166 views4 answers
Sqlite describe table
SQL

Share