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 vote243 views1 answer
Sql count null as 0
SQL
0 vote233 views1 answer
Mysql workbench search all tables
SQL
0 vote261 views3 answers
Classement rang mysql 7
SQL
0 vote247 views1 answer
Json not contains mysql
SQL
1 vote240 views1 answer
GROUP BY clause; this is incompati
SQL
2 votes262 views1 answer
Drop sequence
SQL
0 vote258 views2 answers
How to generate a unique random number in mysql
SQL
0 vote266 views1 answer
Mysql listing get a particu particular user firsdt
SQL
2 votes255 views1 answer
Postgresql transaction
SQL
0 vote268 views1 answer
Postgres grep entire database
SQL