/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 vote116 views3 answers
SQL MM/dd/yyyy format
SQL
0 vote104 views1 answer
Restart postgresql.service Failed to restart postgresql.service: Unit not found.
SQL
0 vote121 views1 answer
Mysql export data with a where clause
SQL
0 vote102 views1 answer
Sql remove decimal places
SQL
0 vote100 views1 answer
Mysql isshow
SQL
0 vote112 views1 answer
Sqlite update where exists
SQL
23 votes112 views6 answers
Create table sql server
SQL
13 votes105 views1 answer
Fetch first 5 rows in oracle sql developer
SQL
7 votes115 views2 answers
Sql server drop temp table if exists
SQL
13 votes105 views3 answers
Change data type postgresql
SQL

Share