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

12 votes165 views1 answer
Env var for setting password for root user mysql docker hub
SQL
0 vote157 views1 answer
Inserting values with beekeeper get error null value in column createdAt violates not-null constraint
SQL
1 vote146 views1 answer
Primary key with prefix sql
SQL
1 vote162 views1 answer
Add multiple row table pl sql
SQL
0 vote138 views1 answer
Oracle sql count occurrences of value in column
SQL
0 vote155 views1 answer
What is SQL data store?
SQL
0 vote171 views1 answer
Soql last week
SQL
12 votes142 views4 answers
SQL Where
SQL
1 vote155 views1 answer
Update foreign key value in mysql
SQL
0 vote174 views1 answer
IS THEre any difference between using default and := in plsql
SQL