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 vote174 views1 answer
Case insensitive sql
SQL
0 vote269 views1 answer
Linux upload database to mysql
SQL
6 votes190 views1 answer
SQL insert all columns
SQL
5 votes192 views6 answers
Sql foreign key
SQL
0 vote221 views1 answer
Retornar apenas o ano mysql date
SQL
6 votes181 views2 answers
Mysql convert timestamp to date
SQL
0 vote205 views1 answer
Postgres copy command
SQL
0 vote184 views3 answers
Drop multiple columns in sql
SQL
0 vote220 views1 answer
Display all node label neo4j
SQL
1 vote181 views1 answer
Import database from a file using mysql commandline
SQL