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

2 votes182 views2 answers
Mysql add hours to time field
SQL
1 vote172 views1 answer
Mysqlworkbench Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
8 votes168 views2 answers
Mysql get first x characters
SQL
0 vote170 views1 answer
Aktor yang pernah terlibat di film bergenre Aksi di sql
SQL
13 votes180 views4 answers
Mysql select last 10 rows
SQL
2 votes175 views1 answer
Mysql select default if null
SQL
0 vote154 views1 answer
Get only structure database mysql
SQL
0 vote172 views1 answer
Add a new column into table
SQL
0 vote184 views1 answer
Https://livesql.oracle.com/apex/livesql/s/l8fedwph53gt5gigbacwvu6m0
SQL
1 vote188 views2 answers
Mysql limit offset
SQL