/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

0 vote195 views1 answer
H2 auto increment and unique
SQL
0 vote209 views1 answer
Limit in access query
SQL
14 votes238 views5 answers
Set password for postgres user ubuntu
SQL
1 vote198 views1 answer
Setval pgsql
SQL
2 votes254 views1 answer
Oracle virtual column
SQL
0 vote220 views1 answer
Mysql Puede ser solamente un campo automatico y este debe ser definido como una clave
SQL
1 vote187 views1 answer
CREATE DATABASE db; SyntaxError: Unexpected identifier
SQL
0 vote183 views1 answer
Mysql> grant all privileges on *.* to root@localhost identified by 'password' with grant option;
SQL
0 vote194 views1 answer
Formatting code with SQL Developer
SQL
2 votes233 views3 answers
Xampp mysql database not starting
SQL

Share