/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 vote188 views1 answer
Table infromation in sql server
SQL
0 vote193 views1 answer
Datagrip execute procedure
SQL
1 vote175 views3 answers
Epoch to datetime
SQL
0 vote190 views2 answers
Don't know how to set rpath on your system, if MySQL libraries are not in path mysql2 may not load
SQL
12 votes191 views5 answers
Rename table in mysql
SQL
0 vote175 views1 answer
How to use group_concat in sql server
SQL
4 votes173 views2 answers
DB::transaction
SQL
1 vote201 views1 answer
What is in condition in sql
SQL
0 vote194 views2 answers
Nodejs mysql convert to plain object
SQL
1 vote185 views1 answer
Mysql show queries running
SQL

Share