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

36 votes305 views6 answers
Rename table sql
SQL
0 vote319 views1 answer
Oracle NLS_CHARACTERSET
SQL
0 vote320 views1 answer
Oracle list datafiles
SQL
0 vote291 views1 answer
Get foreign table names mysql
SQL
1 vote319 views1 answer
How to select all attributes from a row if there is a certain string in it MySQL
SQL
2 votes364 views5 answers
Tablespace ORACLE
SQL
0 vote285 views1 answer
Criteria builder select subset of column
SQL
1 vote295 views1 answer
Mariadb case switch
SQL
7 votes306 views2 answers
Create index mysql cli
SQL
6 votes322 views2 answers
Sql sequence
SQL