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 votes312 views3 answers
How to get last row of table in sql
SQL
0 vote325 views1 answer
Python mysql show databases
SQL
16 votes298 views3 answers
Tsql rename column name
SQL
0 vote272 views1 answer
Strat with in sql
SQL
1 vote342 views1 answer
Oracle select first row order by
SQL
1 vote281 views1 answer
Oracle user last connected
SQL
0 vote284 views1 answer
Porcentaje sql
SQL
0 vote292 views1 answer
Mysql coonect sample code
SQL
0 vote281 views1 answer
Sql max min
SQL
0 vote273 views1 answer
Postgresql copy backup table
SQL