/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

3 votes236 views1 answer
RENAME table pl sql
SQL
0 vote204 views1 answer
Power bi union columns
SQL
2 votes218 views1 answer
Oracle list duplicates
SQL
0 vote222 views1 answer
How to update date value in sql
SQL
0 vote179 views1 answer
Sql developer export connections
SQL
1 vote211 views3 answers
Mysql on delete set null
SQL
33 votes178 views2 answers
Postgres how to add field created at
SQL
4 votes180 views1 answer
Id primary key auto generated
SQL
1 vote413 views1 answer
How to make a select in sql
SQL
17 votes196 views2 answers
T_sql contains
SQL

Share