postgres query to show table structure code example
Example 1: show table postgres command
PostgreSQL show tables command
\dt
Example 2: show details of table postgres
postgres=# \d tablename;
PostgreSQL show tables command
\dt
postgres=# \d tablename;