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 votes345 views1 answer
How to create sql database
SQL
0 vote371 views1 answer
Select year from dual oracle
SQL
0 vote348 views2 answers
Starts and end with vowel sql
SQL
0 vote341 views1 answer
Php select data from mysql database without column name
SQL
0 vote330 views1 answer
Configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
SQL
3 votes389 views2 answers
Savepoint in sql
SQL
1 vote333 views3 answers
Sql select only time from datetime
SQL
0 vote332 views1 answer
Reset postgresql password windows
SQL
0 vote330 views1 answer
How to get initials in sql
SQL
1 vote329 views1 answer
Sql myisam vs innodb
SQL