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 vote195 views1 answer
Left join in codeigniter query builder
SQL
1 vote200 views2 answers
Sql where keyword
SQL
5 votes216 views3 answers
MySql get fields of table
SQL
0 vote197 views1 answer
Price-colour
SQL
0 vote204 views1 answer
Use where instead of join
SQL
2 votes207 views2 answers
Mysql show table column comments sql
SQL
3 votes210 views1 answer
Only join in sql
SQL
4 votes201 views2 answers
Xampp mysql database server is not starting mac m1
SQL
2 votes212 views1 answer
SQL IF ELSE
SQL
0 vote209 views1 answer
Where field is null sql knex
SQL