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 vote336 views1 answer
Order by ip address sql
SQL
27 votes357 views6 answers
Sql update record
SQL
0 vote372 views2 answers
Mysql calcular idade
SQL
0 vote347 views1 answer
Rename view mysql
SQL
0 vote347 views1 answer
Load utilities in sql server
SQL
2 votes306 views1 answer
Sql select in list
SQL
2 votes343 views2 answers
How to DROP a table in mysql
SQL
1 vote363 views1 answer
Mysql list bigger table
SQL
0 vote328 views1 answer
Postgres select except
SQL
1 vote382 views2 answers
Maximum number of tables in mysql
SQL