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

1 vote204 views2 answers
Begin transaction in sql
SQL
1 vote206 views1 answer
How to select all attributes from a row if there is a certain string in it MySQL
SQL
1 vote206 views1 answer
Convert varchar to int in sqlite
SQL
4 votes191 views3 answers
Mysql varchar length
SQL
0 vote203 views1 answer
Oracle current timestamp insert statement
SQL
0 vote314 views1 answer
How to delete duplicate rows in oracle
SQL
6 votes207 views3 answers
Mysql first day of year
SQL
1 vote201 views1 answer
Mysql get last insert id
SQL
0 vote201 views1 answer
Get all employees if name ends with in sql
SQL
3 votes316 views3 answers
Mysql get table size
SQL