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 vote321 views1 answer
How to use select union and loop
SQL
3 votes347 views2 answers
@sqlresultsetmapping
SQL
7 votes327 views3 answers
Restore postgres database from sql file
SQL
0 vote348 views1 answer
Insert ip address in mysql
SQL
20 votes340 views3 answers
How to open postgresql in mac
SQL
2 votes335 views1 answer
Oracle run_duration average
SQL
13 votes318 views2 answers
Mysql order by multiple columns
SQL
4 votes420 views3 answers
Mysql get column names from table
SQL
0 vote375 views1 answer
Find and replace query in wordpress\
SQL
0 vote299 views7 answers
10 random questions use python and SQL
SQL