/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 vote318 views1 answer
Postgres change the name of schema
SQL
1 vote317 views3 answers
Sql union
SQL
0 vote307 views1 answer
Ms sql print more than 1 variable
SQL
0 vote311 views1 answer
Load SQLite in Jupyter Notebook together with the access to the file
SQL
1 vote285 views1 answer
Oracle sql assign unique number to each grouping
SQL
0 vote304 views1 answer
What is the difference between the LIKE and REGEXP operators in mysql?
SQL
-1 vote291 views1 answer
Mysql delete duplicate rows except one
SQL
2 votes301 views1 answer
Postgresql change value in column
SQL
0 vote269 views1 answer
How to count null values in sql
SQL
0 vote299 views1 answer
Show table details postgresql
SQL

Share