/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 vote196 views1 answer
Select insert new table sql server
SQL
0 vote186 views1 answer
Snap craft
SQL
4 votes191 views1 answer
Oracle error line
SQL
0 vote180 views1 answer
Json not contains mysql
SQL
0 vote182 views1 answer
How to print mysql query of codeigniter query builder
SQL
2 votes178 views1 answer
Mysql how to store lat,lng
SQL
0 vote200 views1 answer
Sql combine results from two tables
SQL
0 vote196 views1 answer
Distance calculator from lat long sql query
SQL
14 votes191 views4 answers
Sql compiler
SQL
1 vote187 views1 answer
Mysql show queries running
SQL

Share