/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 vote186 views1 answer
Dual in db2
SQL
7 votes165 views4 answers
What is my mysql version
SQL
0 vote171 views1 answer
Oracle create job if not exists
SQL
3 votes171 views1 answer
Create a table with an id in mysql
SQL
1 vote222 views1 answer
Sqlite create index
SQL
-1 vote172 views1 answer
How to dump .csv file into mysql
SQL
1 vote149 views1 answer
Select from one table where not on the other
SQL
3 votes153 views1 answer
Sql timestamp to date
SQL
0 vote160 views1 answer
Mysql start of today
SQL
2 votes177 views2 answers
How to get the date diff of 2 dates in the same fieldin sql server
SQL

Share