To show database tables first connect to the local PostgreSQL and connect to the database (\c db_name), then you can view database tables list.
Default view
quaded=# \dt
List of relations
Schema | Name | Type | Owner
--------+-------------------+-------+-------
public | alembic_version | table | quaded
public | flask_dance_oauth | table | quaded
public | prices | table | quaded
public | product | table | quaded
public | user | table | quaded
(5 rows)
Detailed view
quaded=# \dt+
List of relations
Schema | Name | Type | Owner | Size | Description
--------+-------------------+-------+-------+------------+-------------
public | alembic_version | table | quaded | 8192 bytes |
public | flask_dance_oauth | table | quaded | 16 kB |
public | prices | table | quaded | 8192 bytes |
public | product | table | quaded | 16 kB |
public | user | table | quaded | 8192 bytes |
(5 rows)