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

7 votes411 views2 answers
How to create index mysql
SQL
0 vote375 views2 answers
Enter into postgresql database,create user and grant Access
SQL
0 vote357 views1 answer
Describe in sqlite3
SQL
0 vote376 views1 answer
Openquery insert into linked server
SQL
0 vote378 views1 answer
Postgresql port 5432 not open
SQL
0 vote384 views1 answer
Create table like sql
SQL
0 vote373 views1 answer
Sql select all records from all tables where not empty
SQL
0 vote407 views1 answer
Move table to a different schema
SQL
1 vote392 views2 answers
Remove space in mysql
SQL
0 vote360 views1 answer
Sql tabelle erstellen
SQL