Postgre describe table

Describe table postgres

postgres=# \d schema.tablename;

Source: postgresqltutorial.com

Show details of table postgres

postgres=# \d tablename;

Postgre describe table

        
            
        
     SELECT 
   table_name, 
   column_name, 
   data_type 
FROM 
   information_schema.columns
WHERE 
   table_name = 'city';

Source: postgresqltutorial.com

Similar codes

0 vote274 views1 answer
Comma seperated join mssql
SQL
8 votes295 views1 answer
Script to add datafile to tablespace
SQL
1 vote310 views1 answer
T-SQL / AZURE Reseed
SQL
0 vote276 views1 answer
Output to file mysql
SQL
0 vote296 views1 answer
Function plsql
SQL
0 vote316 views2 answers
Temp Space
SQL
0 vote278 views1 answer
Sql get month and year from date
SQL
3 votes283 views3 answers
Cannot truncate a table referenced in a foreign key constraint
SQL
12 votes281 views4 answers
Install mysql ubuntu 18.04
SQL
25 votes311 views6 answers
How to change column name in mysql
SQL