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

1 vote232 views1 answer
Oracle rolling back
SQL
1 vote235 views1 answer
Oracle list data files
SQL
0 vote242 views1 answer
Linebreak sql
SQL
2 votes239 views2 answers
Postgresql search all tables for column name
SQL
0 vote268 views1 answer
SQLServerException.makeFromDatabaseError
SQL
0 vote232 views2 answers
Demmarrer un service mysql teminal cmd
SQL
0 vote250 views1 answer
Group by join columns per table
SQL
7 votes264 views2 answers
Mysql check db size
SQL
0 vote238 views1 answer
Inserted row count tsql
SQL
0 vote211 views1 answer
Mysql create table columns with spaces
SQL