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

11 votes118 views2 answers
Oracle all source
SQL
1 vote150 views1 answer
Sql server set variable if exists
SQL
12 votes129 views1 answer
How to change the value of a table in sql
SQL
2 votes142 views1 answer
Install postgresql centos 5
SQL
0 vote188 views1 answer
How to get number of months between 2 dates sql server
SQL
0 vote127 views1 answer
Sqlplus change user
SQL
2 votes85 views1 answer
Sql group by different columns
SQL
0 vote114 views1 answer
Sql select lowest value row
SQL
5 votes146 views1 answer
Ora-00054 resource busy and acquire with nowait
SQL
10 votes124 views1 answer
Oracle view dependencies
SQL