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

0 vote176 views1 answer
Sql server alter table add column tinyint
SQL
0 vote207 views1 answer
Trigger stock phpmyadmin
SQL
2 votes181 views3 answers
Mysql list tables by size
SQL
0 vote166 views1 answer
Mysql user set plugin
SQL
0 vote215 views1 answer
Error code 1215 cannot add foreign key constraint
SQL
1 vote164 views2 answers
Install mysqldump ubuntu
SQL
0 vote193 views1 answer
Space not removing from column in sql
SQL
0 vote164 views1 answer
Add multiple field in table sql
SQL
0 vote180 views1 answer
"/** MySQL database password */" ext:txt | ext:cfg | ext:env | ext:ini
SQL
5 votes166 views2 answers
Copy data from one database to another
SQL