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 vote251 views2 answers
How to install psql in ubuntu
SQL
15 votes185 views2 answers
Install mysql 8 ubuntu 18.04
SQL
1 vote201 views1 answer
Multiple count in sql
SQL
0 vote245 views1 answer
Drush run sql select
SQL
0 vote206 views1 answer
Sqlplus change user
SQL
0 vote199 views1 answer
Get time component of datetime sql
SQL
5 votes223 views4 answers
SQL Order of execution
SQL
-1 vote201 views3 answers
SQL to LINQ converter
SQL
0 vote211 views1 answer
Kill thread
SQL
0 vote265 views3 answers
Classement rang mysql 7
SQL