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 vote91 views0 answer
SQL
20 votes145 views6 answers
Creating a table in sql
SQL
16 votes133 views4 answers
Ascending order mysql
SQL
0 vote132 views1 answer
How to get inserted id in sql server
SQL
4 votes126 views2 answers
Oracle default date format
SQL
1 vote142 views2 answers
Mysql between
SQL
8 votes205 views1 answer
Oracle search code in packages
SQL
31 votes142 views2 answers
Grant all priviledges to mysql user
SQL
2 votes140 views1 answer
Metasploit start postgresql
SQL
2 votes159 views2 answers
Asp.net core with postgresql deploy on ubuntu
SQL