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

8 votes352 views1 answer
Mysql limit rows
SQL
23 votes312 views4 answers
How to uninstall postgresql in ubuntu
SQL
2 votes303 views6 answers
In in sql
SQL
0 vote347 views1 answer
How to enable mysql 5.7 root user password on linux
SQL
0 vote335 views5 answers
ABC TO FLEX BATTLE IM POOR
SQL
6 votes362 views2 answers
Oracle trigger
SQL
0 vote321 views1 answer
Test database for sql
SQL
0 vote309 views1 answer
Sqlite update where exists
SQL
6 votes326 views2 answers
Psql load dump
SQL
5 votes295 views1 answer
Oracle asynchronous procedure
SQL