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 vote137 views1 answer
Implizite joins sql
SQL
0 vote125 views1 answer
How to find unique key in sql
SQL
0 vote133 views1 answer
Sql how to display two atributes as one in sql
SQL
15 votes164 views4 answers
Sql update from select
SQL
12 votes137 views2 answers
Select into insert sql server
SQL
3 votes139 views1 answer
Async await mysql nodejs
SQL
0 vote137 views2 answers
Identity syntax in sql
SQL
0 vote139 views1 answer
Call object contructor and call methods of object
SQL
92 votes363 views6 answers
Substring
SQL
0 vote106 views1 answer
Query for maximum salary
SQL