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

16 votes190 views4 answers
Mysql import from sql file
SQL
0 vote198 views1 answer
Buscar nombre de columna en todas las tablas sql server
SQL
0 vote205 views1 answer
Product of a column in mysql
SQL
1 vote170 views1 answer
Sql Split string function
SQL
2 votes205 views2 answers
How to rename column name in sql server using query
SQL
3 votes195 views1 answer
Oracle get trigger ddl
SQL
1 vote185 views1 answer
Mysql get last insert id
SQL
5 votes173 views2 answers
Add column postgres with default value
SQL
1 vote205 views1 answer
Postgres see sequence current state
SQL
1 vote194 views2 answers
How to search date in sql query
SQL