/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 vote275 views1 answer
How to check event scheduler status mysql
SQL
3 votes239 views1 answer
Get all elements sql
SQL
1 vote270 views1 answer
Declare table variable
SQL
1 vote267 views2 answers
Postgres cast as decimal
SQL
-1 vote280 views1 answer
Sql show custom constraints
SQL
0 vote261 views3 answers
Sql delete all except
SQL
1 vote292 views1 answer
Show databases mysql docker
SQL
0 vote225 views1 answer
Query for maximum salary
SQL
3 votes251 views3 answers
Stop mysql service ubuntu
SQL
5 votes247 views2 answers
Update all rows mysql
SQL

Share