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 vote111 views1 answer
Compare field sql server
SQL
1 vote110 views2 answers
Sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file
SQL
17 votes120 views4 answers
Show tables sql server
SQL
0 vote122 views2 answers
Sql query inner join 3 tables
SQL
0 vote113 views1 answer
Postgresql function ROUND
SQL
1 vote139 views1 answer
OSError: mysql_config not found
SQL
0 vote117 views1 answer
Sql remove non numeric characters
SQL
2 votes116 views1 answer
Sql create database
SQL
1 vote109 views1 answer
Pentaho + pasar de excel a sql
SQL
0 vote174 views1 answer
Insert query return id mysql
SQL