/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

1 vote154 views1 answer
Isnull sql server
SQL
0 vote168 views1 answer
Is not numeric sql
SQL
0 vote179 views1 answer
Can we rollback data that are deleted using DELETE clause?
SQL
0 vote195 views1 answer
Sqlalchemy orm duplicate
SQL
0 vote148 views1 answer
Add sqlite3 in lumen
SQL
0 vote153 views1 answer
Mysql select smaller of two values
SQL
0 vote168 views1 answer
Sql statement show all emails with dome
SQL
0 vote172 views1 answer
Mysql insert into select transaction c#
SQL
0 vote162 views1 answer
Sql value exists in column
SQL
1 vote151 views1 answer
Mariadb alter user host
SQL

Share