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

4 votes204 views3 answers
Check if two date ranges overlap sql server
SQL
0 vote245 views1 answer
For select oracle
SQL
1 vote201 views1 answer
Mariadb.service: main process exited, code=exited, status=1/failure
SQL
2 votes203 views1 answer
Copy all values of a column to another column in sql in same table
SQL
1 vote209 views1 answer
Postgres left join
SQL
0 vote244 views1 answer
Mysql wsrep ls
SQL
0 vote173 views1 answer
Faire une recherche par liste de mot clé sql
SQL
2 votes188 views1 answer
Oracle table size
SQL
4 votes204 views2 answers
Select first and last row mysql
SQL
10 votes208 views6 answers
Between sql
SQL