/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 vote256 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL
0 vote194 views1 answer
Postgres create extension if not exists
SQL
1 vote189 views1 answer
Mysql check if string contains comma separated
SQL
0 vote286 views1 answer
Copy from one table to another postgres using matching column
SQL
2 votes255 views2 answers
Postgres set user as superuser
SQL
3 votes193 views2 answers
Update Query in SQL Server
SQL
1 vote200 views1 answer
SQL: merging multiple row data in string
SQL
0 vote206 views1 answer
How to get first 10 records of a table in mysql
SQL
0 vote198 views1 answer
Limit and offset in stored procedure mssql
SQL
1 vote205 views1 answer
Mysql column start with string
SQL

Share