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

2 votes220 views1 answer
Oracle table size
SQL
3 votes240 views5 answers
Duplicate table sql
SQL
0 vote249 views1 answer
Date datatype in livesql
SQL
0 vote228 views1 answer
Top 3 salary in sql
SQL
6 votes233 views5 answers
Sql add months to date
SQL
0 vote221 views1 answer
Query to get all primary keys and foreign key
SQL
0 vote245 views2 answers
While mysql
SQL
5 votes217 views4 answers
Select random rows sql
SQL
0 vote221 views2 answers
How to find sql server agent jobs related to a database
SQL
0 vote229 views1 answer
Sql server count all tables rows
SQL