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 vote138 views1 answer
Mysql select all columns and specific fields as
SQL
5 votes137 views2 answers
Mysql import gzip db
SQL
3 votes134 views1 answer
Get current month last date in sql server
SQL
2 votes129 views5 answers
Tablespace ORACLE
SQL
0 vote141 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL
0 vote126 views1 answer
Sql select non unique
SQL
20 votes167 views4 answers
How to find average in sql
SQL
3 votes131 views1 answer
Postgresql db owner change
SQL
0 vote164 views1 answer
Jpa generationtype sequence mysql
SQL
1 vote98 views1 answer
What are the cursors and what are the cursors types? in sql
SQL