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 vote231 views1 answer
Store case result sql
SQL
5 votes209 views1 answer
Oracle columns in all_tables
SQL
2 votes232 views1 answer
Mysql now format
SQL
0 vote218 views1 answer
Oracle merge insert if not exists
SQL
0 vote229 views1 answer
Set root password mysql xampp
SQL
1 vote219 views1 answer
"i_am_a_dummy flag" in MySQL
SQL
1 vote224 views1 answer
How to select multiple columns from different tables in mysql
SQL
0 vote223 views1 answer
Oarcale list objects
SQL
0 vote212 views1 answer
Drop all data from tables
SQL
5 votes210 views2 answers
Mysql drop table cascade
SQL