/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 vote305 views1 answer
Mysql view curren querys
SQL
2 votes275 views1 answer
How to create sql database
SQL
1 vote297 views2 answers
Job for mysql.service failed because the control process exited with error code. see "systemctl status mysql.service" and "journalctl -xe" for details.
SQL
0 vote285 views1 answer
Radius search with point data in mysql
SQL
0 vote222 views1 answer
Copy table dbeaver
SQL
1 vote250 views1 answer
Can we drop a primary key
SQL
0 vote301 views1 answer
Mysql backup query
SQL
6 votes276 views1 answer
T-sql test if table exists
SQL
0 vote264 views1 answer
Alter table name including schema
SQL
8 votes308 views2 answers
Update sql server from another table
SQL

Share