/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 vote282 views1 answer
Rows to comma separated values in mssql
SQL
7 votes290 views2 answers
Create index mysql cli
SQL
2 votes299 views3 answers
Sql truncate table
SQL
0 vote311 views1 answer
Mysql delete entire row on condition
SQL
0 vote302 views1 answer
How to map sql column to custom names
SQL
0 vote266 views1 answer
1 column values in to 1 single row in sql
SQL
8 votes286 views4 answers
How to calculate the age from date of birth in python
SQL
0 vote274 views4 answers
Forenkey code alchemy sql
SQL
0 vote325 views1 answer
Tsql cte in a transaction
SQL
2 votes276 views3 answers
Postgresql reset auto increment
SQL

Share