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 vote399 views1 answer
Datatables server side filter where clause
SQL
4 votes428 views4 answers
Check constraint in ms sql
SQL
0 vote365 views1 answer
Get first 3 letter of department name in sql
SQL
0 vote384 views1 answer
Mysql select random rows large table
SQL
0 vote373 views1 answer
Mysql 8 error on identified by
SQL
20 votes348 views4 answers
Reset auto increment in MySQL
SQL
18 votes352 views6 answers
Mysql create table
SQL
0 vote391 views1 answer
Mysql change default collation
SQL
1 vote357 views1 answer
Oracle convert run duration to number
SQL
1 vote354 views1 answer
How to update date add hours in postgresql
SQL