/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

33 votes137 views6 answers
Change column name in mysql
SQL
0 vote127 views1 answer
Ajouter une contrainte de clé étrangère sql
SQL
0 vote134 views1 answer
View t-sql mail configuration
SQL
0 vote131 views1 answer
Postgresql create table many-to-many
SQL
8 votes130 views5 answers
Grant permission in postgres
SQL
1 vote147 views1 answer
Sysdate in sql
SQL
0 vote174 views1 answer
Sparql if bound query
SQL
1 vote130 views1 answer
Rows to comma separated values in mssql
SQL
1 vote147 views2 answers
Logical operators in sql
SQL
1 vote142 views1 answer
Select random sample sql
SQL

Share