/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 vote190 views1 answer
Mysql faster delete
SQL
0 vote146 views1 answer
Mysql in clausule string array
SQL
0 vote157 views2 answers
How to get last inserted id in sql server c#
SQL
2 votes185 views1 answer
Oracle insert or update
SQL
0 vote152 views1 answer
Databricks install odbc driver connect to sql server
SQL
2 votes107 views1 answer
Foreign key example in dbms
SQL
1 vote112 views1 answer
Import in mysql without a software
SQL
5 votes142 views1 answer
Oracle ora-00054 causes
SQL
1 vote142 views1 answer
How to see logical reads in sql server
SQL
2 votes155 views1 answer
Oracle convert run_duration to number
SQL

Share