/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

5 votes366 views3 answers
Oracle first day of last year
SQL
0 vote416 views1 answer
Insert using condition postgres
SQL
4 votes346 views3 answers
Count with where
SQL
0 vote367 views1 answer
Select nth row in mysql
SQL
1 vote345 views1 answer
Oracle list datafiles in tablespace
SQL
0 vote426 views1 answer
Sql cursor example multiple columns
SQL
40 votes469 views4 answers
PostgreSQL add column
SQL
13 votes358 views2 answers
Sql join
SQL
0 vote370 views1 answer
Sql server set complex constraints
SQL
3 votes357 views3 answers
Cannot truncate a table referenced in a foreign key constraint
SQL

Share