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

6 votes181 views3 answers
Mysql change auto_increment start value
SQL
1 vote150 views1 answer
Raise application error in oracle
SQL
0 vote145 views1 answer
Version and edition of SQL Server Database Engine
SQL
0 vote143 views1 answer
Sql server datetime to string
SQL
0 vote141 views1 answer
Postgres jsonb array push new element
SQL
49 votes221 views6 answers
Get duplicate records in sql
SQL
0 vote152 views1 answer
Mysqlimport
SQL
0 vote170 views1 answer
Sql developer sql worksheet not showing
SQL
0 vote137 views1 answer
Mysql add to value
SQL
0 vote130 views1 answer
Insert thai language sql server
SQL