/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 vote237 views1 answer
Drush run sql select
SQL
0 vote231 views1 answer
Original Query
SQL
5 votes240 views2 answers
To date oracle
SQL
0 vote253 views1 answer
Mssql unique key accept nulls
SQL
0 vote228 views1 answer
Sqlite3 update select
SQL
0 vote244 views1 answer
Wincc 7.4 to sql stackoverflow
SQL
0 vote246 views1 answer
OFFSET consulta mysql
SQL
1 vote233 views1 answer
Sql server select rows by distinct column
SQL
0 vote236 views1 answer
Find and replace database table phpmyadmin
SQL
0 vote251 views1 answer
Edit shchima table in sql
SQL

Share