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

15 votes180 views3 answers
Mysql update add to existing value
SQL
2 votes184 views1 answer
Mariadb json select
SQL
0 vote166 views1 answer
Grouping by email domain mysql
SQL
6 votes194 views1 answer
How to get the size of the database in postgresql
SQL
0 vote159 views1 answer
Hibernate with springboot mysql
SQL
0 vote173 views1 answer
Mysql check datetime equals date
SQL
0 vote167 views1 answer
Sql describe
SQL
11 votes171 views2 answers
Oracle all source
SQL
-1 vote159 views1 answer
Export mysql table to file
SQL
1 vote171 views2 answers
Mysql extract month
SQL