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 vote329 views1 answer
Postgresql create table default value timestamp
SQL
6 votes382 views3 answers
[2021-10-05T13:43:48.961Z] error Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
29 votes348 views6 answers
Delete all rows from table mysql
SQL
2 votes377 views1 answer
Merge firstname and lastname in sql oracle
SQL
0 vote340 views1 answer
Denormalise SQL command
SQL
0 vote355 views1 answer
Query on date sqlite flutter
SQL
2 votes377 views1 answer
Q operator in plsql
SQL
1 vote376 views1 answer
Drop primary key oracle
SQL
0 vote339 views1 answer
Add column not null with default value postgres
SQL
0 vote375 views1 answer
Load data infile mariadb slow
SQL