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

4 votes227 views2 answers
SELECT table_name FROM user_tables;
SQL
2 votes174 views1 answer
Drop table purge
SQL
1 vote180 views1 answer
Postgresql reset serial counter after deleting content
SQL
12 votes175 views4 answers
Install mysql ubuntu 18.04
SQL
0 vote188 views2 answers
Sql join on comma separated field
SQL
0 vote184 views1 answer
Sql server remove 0 from left
SQL
3 votes179 views2 answers
Sql paging query
SQL
9 votes178 views1 answer
Sql server get utc date
SQL
5 votes189 views1 answer
Oracle get foreign keys on table
SQL
0 vote201 views1 answer
Postgresql linux password
SQL