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

1 vote132 views1 answer
Key validation sql
SQL
31 votes133 views4 answers
How to get duplicate records with multiple field in sql
SQL
1 vote127 views1 answer
Add many column to sap iq table
SQL
2 votes142 views3 answers
Sql function
SQL
3 votes118 views1 answer
How to remove characters from string in mysql
SQL
0 vote132 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL
3 votes132 views1 answer
Unsigned int in mysql
SQL
1 vote138 views1 answer
Mysql search like order by best match
SQL
1 vote125 views1 answer
Mysql get max value and id
SQL
4 votes125 views4 answers
Date less than in sql
SQL