When I started with PostgreSQL, I wanted to postgres list tables just like MySQL’s SHOW TABLES. The closest way is to connect to your database using psql and run:
\dt
This shows all tables in your current schema. If you want to see tables in other schemas, you can use \dt schema_name.*.
It’s simple and handy once you get used to psql commands.