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

8 votes127 views1 answer
Oracle add datafile to tablespace
SQL
0 vote121 views2 answers
How to create a table from another table in sql derby
SQL
0 vote126 views1 answer
What is database username and password in mysqliconnect
SQL
1 vote140 views1 answer
Oracle check table lock
SQL
5 votes118 views1 answer
Sql check if date is between 2 dates
SQL
1 vote121 views1 answer
How to remove identity from a column in sql server
SQL
5 votes111 views1 answer
Update sql user password
SQL
8 votes122 views3 answers
Postgres connection string
SQL
0 vote110 views2 answers
Mysql regexp match word
SQL
0 vote119 views1 answer
How to use sqlcommand
SQL