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 vote112 views1 answer
Console output pl sql
SQL
0 vote131 views1 answer
Psql check if sql script is valid
SQL
1 vote119 views2 answers
Oracle list partitioned tables
SQL
0 vote124 views1 answer
Mysql insert multiple rows based on select
SQL
3 votes118 views1 answer
Sql print all names that start with a given letter
SQL
13 votes109 views1 answer
Fetch first 5 rows in oracle sql developer
SQL
5 votes120 views1 answer
How to use rank function in sql
SQL
0 vote148 views1 answer
Dynamic where clause in sql server stored procedure
SQL
0 vote115 views1 answer
Order by number of character in sql
SQL
-1 vote115 views1 answer
Add column alter table default value
SQL