Describe table postgres

postgres=# \d schema.tablename;

Source: postgresqltutorial.com

Describe table query in postgresql

select column_name, data_type, character_maximum_length, column_default, is_nullable
from INFORMATION_SCHEMA.COLUMNS where table_name = '<name of table>';

Postgre describe table

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

Source: postgresqltutorial.com

1) PostgreSQL DESCRIBE TABLE using psql

\d table_name or \d+ table_nameor
        
            
        
     SELECT 
   table_name, 
   column_name, 
   data_type 
FROM 
   information_schema.columns
WHERE 
   table_name = 'city';

Source: postgresqltutorial.com

Similar codes

0 vote189 views1 answer
Select * from mysql.proc
SQL
5 votes186 views1 answer
Ora-00054 resource busy and acquire with nowait
SQL
1 vote161 views1 answer
Mysql random limit 1
SQL
35 votes188 views5 answers
Sql alter column
SQL
1 vote159 views1 answer
Sql get all columns from one table but one from another inner join
SQL
17 votes179 views6 answers
Get last record in sql
SQL
0 vote171 views1 answer
Mysql select where field like in list
SQL
0 vote187 views1 answer
Create a view in sqlite
SQL
25 votes187 views6 answers
Import database mysql command line
SQL
0 vote179 views2 answers
Uninstall postgresql mac
SQL