/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 vote264 views1 answer
Generate random data postgresql
SQL
2 votes269 views1 answer
Column names in oracle sql
SQL
1 vote285 views1 answer
Opensuse restart MySQL
SQL
0 vote296 views1 answer
Typical max-connect-errors mysql
SQL
0 vote250 views1 answer
How to solve ERROR 1049 (42000): Unknown database 'hbtn_0c_0'
SQL
0 vote274 views1 answer
Oracle sql all days except weekends
SQL
2 votes256 views1 answer
Oracle trace file
SQL
2 votes257 views2 answers
Postgres drop column if exists
SQL
1 vote263 views2 answers
Select into temp table
SQL
2 votes247 views1 answer
Select * from table where name like
SQL

Share