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 vote140 views1 answer
Console output pl sql
SQL
1 vote156 views1 answer
SQL date part only of datetime
SQL
36 votes151 views6 answers
Rename table sql
SQL
0 vote142 views1 answer
Shrink database file in sql server
SQL
0 vote159 views2 answers
Replace null with 0 in sql
SQL
0 vote153 views2 answers
Demmarrer un service mysql teminal cmd
SQL
0 vote185 views1 answer
How to check event scheduler status mysql
SQL
12 votes150 views2 answers
Delete all entries postgres
SQL
13 votes145 views2 answers
Oracle select into and inner join
SQL
3 votes147 views1 answer
Oracle list invalid password ORA-01017
SQL