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 votes185 views1 answer
Sql any
SQL
0 vote190 views1 answer
Sql contains vs like
SQL
6 votes182 views4 answers
Delete table sqlite
SQL
1 vote201 views1 answer
Oracle create program if no exists
SQL
1 vote242 views1 answer
Sql where max date
SQL
1 vote184 views1 answer
ELECT list is not in GROUP BY clause and contains nonaggregated column 'schogdsw_db.SE.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
2 votes182 views1 answer
Install sqlite npm
SQL
0 vote193 views1 answer
Mysql Selected All Duplicate Rows
SQL
0 vote238 views1 answer
Parent and child link in mysql
SQL
3 votes210 views3 answers
Illuminate database queryexception could not find driver (sql select * from
SQL