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 vote397 views1 answer
Sqlite schema structure of a relational database
SQL
2 votes342 views1 answer
Search query in mysql
SQL
0 vote262 views1 answer
Msg 241, level 16, state 1, line 1 conversion failed when converting date and/or time from character string.
SQL
1 vote325 views1 answer
Set autoincrement to 0
SQL
0 vote345 views1 answer
Mysqli last row
SQL
9 votes359 views2 answers
Nosql databases
SQL
3 votes341 views1 answer
Sql insert inserted id
SQL
-1 vote351 views5 answers
Not in sql
SQL
6 votes324 views1 answer
Wordpress change user password sql
SQL
2 votes318 views2 answers
Mysql date range
SQL