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

0 vote216 views1 answer
Sql server sleep
SQL
7 votes202 views3 answers
Sql server check if temp table exists
SQL
0 vote186 views1 answer
Dual in db2
SQL
0 vote169 views1 answer
Sql if else in select
SQL
8 votes209 views4 answers
Convert date to dd/mm/yyyy sql
SQL
0 vote162 views1 answer
An exception occurred while executing a transact-sql statement or batch user,group or role already
SQL
0 vote167 views1 answer
How to import sqlite driver class in java using maven
SQL
0 vote176 views1 answer
Is not sql
SQL
0 vote712 views1 answer
Sql show table name in result
SQL
3 votes130 views1 answer
System.debug apex
SQL