Postgresql select all column names

How to list columns for particular tables in postgresql

SELECT *
  FROM information_schema.columns
 WHERE table_schema = 'your_schema'
   AND table_name   = 'your_table'
     ;

Source: dba.stackexchange.com

Postgresql select all column names

SELECT column_names
  FROM information_schema.columns
 WHERE table_schema = 'your_schema'
   AND table_name   = 'your_table'
     ;
-- just for column names

Similar codes

2 votes272 views1 answer
Set boolean flasksql
SQL
3 votes270 views1 answer
Force using index oracle
SQL
0 vote295 views1 answer
How do you insert boolean to postgresql
SQL
-1 vote277 views1 answer
Partial search in sql
SQL
0 vote288 views1 answer
Postgresql delete type
SQL
38 votes359 views6 answers
Ubuntu install mysql client
SQL
5 votes262 views4 answers
Sql check
SQL
0 vote308 views1 answer
Disable database droping sql
SQL
1 vote290 views1 answer
Sql server today minus n
SQL
0 vote272 views1 answer
Sqlalchemy case insensitive like
SQL