/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

13 votes204 views6 answers
Mysql update from select
SQL
0 vote198 views1 answer
Select from another database
SQL
5 votes186 views1 answer
Sql asynchronous stored procedure call
SQL
18 votes204 views3 answers
'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004',
SQL
4 votes203 views1 answer
Add constraint fk
SQL
5 votes271 views3 answers
Create function in postgresql
SQL
5 votes214 views1 answer
Oracle list days between two dates
SQL
0 vote197 views1 answer
Grant privileges of databse to user
SQL
0 vote210 views1 answer
Procedures sql insert mysql
SQL
2 votes242 views1 answer
Pandas to sql index
SQL

Share