/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

2 votes164 views2 answers
How to create an empty table from an existing table
SQL
0 vote167 views2 answers
Django.db.utils.OperationalError: (1698, "Access denied for user 'root'@'localhost'")
SQL
4 votes189 views3 answers
Sql drop primary key
SQL
1 vote170 views1 answer
Sql server 2012 query history
SQL
0 vote177 views1 answer
Hive batch drop table
SQL
0 vote185 views1 answer
Use between operator in mysql
SQL
0 vote174 views1 answer
Create table Statement Syntax in SQL Server
SQL
7 votes197 views3 answers
Can't connect to local mysql server through socket '/tmp/mysql.sock' (2)
SQL
13 votes194 views2 answers
Sql join 3 tables
SQL
10 votes185 views4 answers
How to alter table name in mysql
SQL

Share