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 vote99 views1 answer
Sql exclude duplicates and find even id
SQL
0 vote101 views1 answer
Sql count * vs count 1
SQL
1 vote139 views1 answer
Postgresql where datetrunc month and year equal
SQL
0 vote103 views1 answer
Postgresql if else endif
SQL
0 vote99 views3 answers
Sql drop all tables
SQL
1 vote97 views1 answer
Media sql
SQL
0 vote108 views1 answer
Mysql pad zeros
SQL
2 votes156 views1 answer
Postgresql group by month and year
SQL
0 vote227 views2 answers
SQL SERVER ORDER BY DATE NULL LAST
SQL
5 votes111 views1 answer
AND OR NOT operators sql
SQL