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 vote348 views1 answer
Execute sql stored procedure in powershell
SQL
0 vote338 views1 answer
"inspanel" intitle:"login" -"cannot" "Login ID" -site:luckyfish.io
SQL
0 vote367 views1 answer
How to get column name in db from an sqlalchemy attribute model
SQL
12 votes334 views2 answers
Delete all entries postgres
SQL
11 votes368 views2 answers
Having clause in sql
SQL
0 vote395 views1 answer
Pagination with row_number
SQL
12 votes363 views2 answers
Insert multiple rows from another table sql
SQL
0 vote364 views1 answer
Mysql edit trigger
SQL
0 vote390 views2 answers
Suse Linux restart MySQL
SQL
0 vote336 views1 answer
Oracle step procedure
SQL