Psql show columns of table

Show details of table postgres

postgres=# \d tablename;

Psql show columns of table

SELECT 
   table_name, 
   column_name, 
   data_type 
FROM 
   information_schema.columns
WHERE 
   table_name = 'city';Code language: SQL (Structured Query Language) (sql)

Source: postgresqltutorial.com

Postgre describe table

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

Source: postgresqltutorial.com

Similar codes

7 votes151 views1 answer
Mysql iif
SQL
5 votes173 views3 answers
Db begintransaction laravel
SQL
2 votes146 views1 answer
SELECT INTO
SQL
0 vote203 views1 answer
SQL Server Altering Column to be Unique
SQL
0 vote149 views1 answer
[object Object]: BY KimbleOne__DeliveryGroup__c, CreatedDate ^ ERROR at Row:1:Column:142 field 'CreatedDate' can not be grouped in a query call
SQL
0 vote164 views1 answer
How to user id to show in from date to upto date in mssql server
SQL
0 vote160 views1 answer
Mysqldump don't drop table
SQL
0 vote142 views1 answer
Postgresql find missing id
SQL
0 vote134 views1 answer
Dasebase_url-postgres for windows
SQL
14 votes151 views3 answers
Sql trim from string
SQL