/SQL/List columns in table postgres

List columns in table postgres

How to list columns for particular tables in postgresql

SELECT *
  FROM information_schema.columns
 WHERE table_schema = 'your_schema'
   AND table_name   = 'your_table'
     ;

2

Source: dba.stackexchange.com

List columns in table postgres

-- Good for quickly reminding you of what columns exist.
SELECT * FROM mytable WHERE 1=0;

1

Postgresql list columns

SELECT * FROM information_schema.columns 
WHERE table_schema = 'your_schema'
  AND table_name = 'your_table';

0

Similar codes

1 vote402 views1 answer
Mysql update inner
SQL
4 votes361 views1 answer
Wildcard in sql
SQL
4 votes345 views2 answers
SELECT table_name FROM user_tables;
SQL
5 votes348 views3 answers
How to remove unique key constraint in mysql
SQL
33 votes427 views6 answers
Sql delete
SQL
0 vote345 views1 answer
Console output pl sql
SQL
0 vote344 views3 answers
Mysqli count down
SQL
0 vote366 views1 answer
Longtext sql
SQL
0 vote391 views1 answer
Bigrock database connection string
SQL
0 vote372 views1 answer
Multiple like values for single column postgres
SQL

Share