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

5 votes112 views2 answers
Mysql drop table cascade
SQL
0 vote99 views1 answer
Drop all tables in azure sql database
SQL
8 votes127 views2 answers
How to fetch data from database without last column
SQL
0 vote101 views1 answer
Sql check for null and empty string
SQL
0 vote151 views1 answer
Capabilities of sql select statements
SQL
6 votes104 views1 answer
Oracle list primary key
SQL
0 vote106 views1 answer
Sql min
SQL
0 vote114 views1 answer
Setval postgres example table id
SQL
0 vote122 views1 answer
Update sqlite
SQL
0 vote102 views1 answer
Oracle search columns in schema
SQL