/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 vote321 views1 answer
St_buffer mysql
SQL
1 vote324 views1 answer
Sql pick random row
SQL
9 votes334 views4 answers
How to alter table column name in mysql
SQL
0 vote334 views1 answer
Sql column contains special character
SQL
1 vote333 views1 answer
What is a Database?
SQL
0 vote307 views1 answer
Sql track modification
SQL
7 votes362 views2 answers
Sql remove duplicates based on column
SQL
104 votes521 views2 answers
Like in mysql
SQL
5 votes330 views1 answer
Sysdate in oracle sql
SQL
0 vote327 views1 answer
Full outer join in mariadb mysql
SQL

Share