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 vote118 views1 answer
Drop all tables in azure sql database
SQL
0 vote124 views1 answer
Mariadb maximum left join
SQL
2 votes150 views1 answer
Postgresql resolv duplicate value violates unique constraint
SQL
0 vote127 views2 answers
Mysql on update current_timestamp
SQL
4 votes121 views2 answers
Sql server date now
SQL
34 votes122 views6 answers
Sql change data type
SQL
0 vote167 views1 answer
Error code 1215 cannot add foreign key constraint
SQL
0 vote127 views1 answer
Best sql collation
SQL
0 vote123 views3 answers
Postgres trim string
SQL
0 vote122 views1 answer
Mariadb LOAD DATA INFILE
SQL