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

1 vote177 views1 answer
Find a column in all tables postgres
SQL
2 votes170 views1 answer
Alter table add column and foreign key mysql
SQL
27 votes213 views5 answers
Mysql set password for user
SQL
0 vote187 views1 answer
Google cloud sql postgres url example
SQL
0 vote173 views1 answer
How to put 0 or 000 depending IDCustomer length in sql server
SQL
103 votes2.4K views1 answer
Like sql
SQL
1 vote211 views1 answer
Mysql print variable
SQL
0 vote190 views2 answers
SQLSTATE[HY000]: General error: 3780 Referencing column 'role_id' and referenced column 'id' in foreign key constraint 'user_role_id foreign' are incompatible.
SQL
0 vote185 views1 answer
Casterar postgres
SQL
0 vote185 views2 answers
List all constraints in postgres
SQL