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

10 votes237 views1 answer
Oracle all_dependencies
SQL
3 votes170 views4 answers
Ubuntu stop mysql
SQL
10 votes140 views2 answers
Mysql select timestamp group by day
SQL
1 vote277 views1 answer
Aqua Data studio postgresql ssl
SQL
5 votes206 views2 answers
Postgresql insert select
SQL
1 vote125 views1 answer
Metada in sql
SQL
0 vote221 views1 answer
Original Query
SQL
0 vote167 views1 answer
Stored procedure function relation
SQL
0 vote217 views1 answer
Mysql grant user wildcard database
SQL
0 vote182 views1 answer
Less mysql display
SQL