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

0 vote209 views1 answer
Sql count total by foreign key
SQL
0 vote183 views1 answer
Run postgresql dump to csv
SQL
0 vote219 views1 answer
Openquery join two tables
SQL
0 vote184 views2 answers
Tsql row number
SQL
0 vote175 views1 answer
Remove default constraint sql server
SQL
0 vote186 views1 answer
How to check which sp is running in sql server
SQL
2 votes187 views1 answer
Mysql change data type of column
SQL
0 vote195 views1 answer
DELETE DUPLICATE VALUES FROM A TABLE IN SQL SERVER
SQL
0 vote195 views1 answer
Unique index in mysql
SQL
0 vote362 views1 answer
Install mysql on bash
SQL