/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

7 votes339 views6 answers
Group_concat in mysql
SQL
0 vote348 views1 answer
SQLite3::SQLException: table "categories" already exists: CREATE TABLE "categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL
SQL
1 vote393 views1 answer
Best configuration for display table in sqlplus
SQL
0 vote340 views1 answer
Access mysql database docker container shell
SQL
1 vote328 views1 answer
Oracle apex prevent initial load
SQL
0 vote329 views1 answer
Postgres declare variable
SQL
0 vote400 views1 answer
Remove mysql from centos 7
SQL
1 vote391 views1 answer
Import sql file from laravel
SQL
3 votes332 views1 answer
Sql multi column index performance
SQL
0 vote337 views2 answers
Create sequence if not exists postgres
SQL

Share