show details of table postgres
snippet in sql

describe table postgres

user1407

postgres=# \d schema.tablename;

show details of table postgres

user6358

postgres=# \d tablename;