/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

0 vote281 views1 answer
Output table plsql
SQL
28 votes287 views4 answers
Show tables mysql
SQL
0 vote321 views1 answer
Get role postgres
SQL
-1 vote283 views3 answers
Error mysql shutdown unexpectedly
SQL
12 votes285 views2 answers
Delete all nodes neo4j
SQL
1 vote290 views1 answer
Mysql current running queries
SQL
0 vote302 views2 answers
Mysql where in maintain order group_concat
SQL
13 votes286 views2 answers
Sql count distinct group by
SQL
0 vote318 views1 answer
Distance calculator from lat long sql query
SQL
2 votes316 views3 answers
Mysql kill
SQL

Share