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 vote101 views1 answer
Compare two tables to find unmatched records
SQL
0 vote109 views1 answer
Postgresql create table with boolean column
SQL
0 vote112 views1 answer
Access mysql database docker container shell
SQL
0 vote103 views1 answer
Sql view index
SQL
0 vote103 views1 answer
How to print out column name differently in mysql
SQL
0 vote121 views3 answers
Mysql keyword search
SQL
0 vote118 views1 answer
Mysql make date from 2 column
SQL
1 vote117 views1 answer
Postgres install unaccent extension
SQL
0 vote110 views1 answer
Increase speed of like queries postgres
SQL
0 vote118 views1 answer
Hex string sql becomes int64
SQL