/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 votes118 views2 answers
Current year sql
SQL
1 vote134 views1 answer
Name of today sql
SQL
0 vote118 views1 answer
Aktor yang pernah terlibat lebih dari 3 film di sql
SQL
22 votes131 views6 answers
Create sql table
SQL
0 vote132 views1 answer
Select row with latest date mysql
SQL
58 votes288 views4 answers
Mysql drop column
SQL
14 votes131 views2 answers
Oracle export trigger ddl
SQL
5 votes125 views2 answers
Create table mysql example auto_increment
SQL
0 vote144 views1 answer
Mysql insert into select transaction c#
SQL
0 vote124 views1 answer
Get number of table colums in sql query
SQL

Share