/SQL/Postgresql list columns

Postgresql list columns

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

11 votes143 views5 answers
Sql server reset identity
SQL
0 vote134 views1 answer
Odd record sql query
SQL
3 votes126 views3 answers
C# sql select
SQL
5 votes137 views1 answer
Get table columns from sql
SQL
0 vote121 views1 answer
Transalations from sql to Linq count and group by
SQL
0 vote131 views1 answer
Mysql vs sql server performance benchmark
SQL
13 votes200 views4 answers
Mysql remove foreign key constraint
SQL
1 vote142 views1 answer
Oracle stop
SQL
-1 vote146 views1 answer
How to Activate the database
SQL
0 vote144 views1 answer
Insert or update sql firebird
SQL

Share