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 vote249 views1 answer
Sql track modification
SQL
3 votes214 views5 answers
Foreign keys
SQL
0 vote189 views1 answer
Sauvegarde complète my sql
SQL
6 votes193 views2 answers
Can't connect to local mysql server through socket
SQL
4 votes235 views1 answer
Postgresql create table with index
SQL
1 vote199 views2 answers
Snowflake alter column data type
SQL
0 vote191 views2 answers
Alter table add multiple columns mysql
SQL
2 votes180 views2 answers
Join update query in sql
SQL
11 votes235 views1 answer
How to get ddl for materialized view
SQL
28 votes190 views4 answers
Delete database mysql
SQL