Postgre describe table

Describe table postgres

postgres=# \d schema.tablename;

Source: postgresqltutorial.com

Show details of table postgres

postgres=# \d tablename;

Postgre describe table

        
            
        
     SELECT 
   table_name, 
   column_name, 
   data_type 
FROM 
   information_schema.columns
WHERE 
   table_name = 'city';

Source: postgresqltutorial.com

Similar codes

6 votes175 views1 answer
Oracle list primary key
SQL
1 vote173 views2 answers
Sql select only first occurrence
SQL
2 votes211 views3 answers
Oracle show column of table
SQL
0 vote235 views1 answer
Mysql error 1114 (hy000) the table is full
SQL
2 votes199 views2 answers
How to rename column name in sql server using query
SQL
0 vote187 views2 answers
Plsql function that return a table
SQL
2 votes181 views1 answer
SQLSTATE[HY000] [1049] Unknown database
SQL
0 vote179 views1 answer
Sql how to get courses that i have made prerequisites
SQL
1 vote182 views1 answer
Sql exclude duplicates and find even id
SQL
2 votes143 views1 answer
Latest record in sql
SQL