/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 vote302 views1 answer
Delete a temporary table mysql
SQL
3 votes258 views2 answers
Oracle for loop
SQL
0 vote304 views1 answer
Add new column in sql with foreign key
SQL
11 votes288 views2 answers
Mysql set safe mode off
SQL
0 vote263 views1 answer
Show all mongodb
SQL
3 votes276 views2 answers
Laravel tosql with bindings
SQL
0 vote266 views1 answer
Postgresql if else endif
SQL
0 vote303 views1 answer
Sqlite trim
SQL
13 votes272 views5 answers
Sql default
SQL
0 vote289 views2 answers
Create-toys-table-with-toy_name-column
SQL

Share