/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 vote221 views3 answers
Condition in count sql
SQL
0 vote199 views1 answer
Sql search all columns of database oracle sql
SQL
0 vote221 views4 answers
What is unique key in sql
SQL
0 vote192 views1 answer
Oracle call a function in a insert statement
SQL
0 vote186 views1 answer
Online sql testing tool
SQL
2 votes236 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly. 11:04:35 PM [mysql] This may be due to a blocked port, missing dependencies,
SQL
6 votes214 views2 answers
Difference between join vs union
SQL
3 votes219 views2 answers
Host '' is not allowed to connect to this MySQL server
SQL
0 vote247 views1 answer
Port 5432 is already in use Usually this means that there is already a PostgreSQL server running on your Mac. If you want to run multiple servers simultaneously, use different ports.
SQL
0 vote186 views1 answer
Hibernate xml property MySQL url, username and password
SQL

Share