/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 vote372 views1 answer
Mariadb.service: main process exited, code=exited, status=1/failure
SQL
1 vote341 views1 answer
Lpad function in sql oracle
SQL
0 vote331 views1 answer
Oracle sqlp update amount / quantity
SQL
1 vote381 views1 answer
Wherein mysql
SQL
5 votes345 views1 answer
Alter table add comment oracle
SQL
14 votes362 views2 answers
Oracle export trigger ddl
SQL
0 vote348 views1 answer
Sqlalchemy query join many to many
SQL
10 votes338 views3 answers
Insert into auto increment mysql
SQL
-1 vote380 views1 answer
Mysql faster insert
SQL
0 vote334 views2 answers
Postgresql create role
SQL

Share