We can list all tables in a PostgreSQL database using query below:
SELECT table_name FROM information_schema.tables WHERE table_schema not in ('information_schema', 'pg_catalog') ORDER BY table_name
As a result, you will get a list of all tables:
If you are using psql, you can list all tables simply by using the following command:
With ERBuilder Data Modeler, you can visualize all the tables as a list or as an ER Diagram. You can also explore and browse any table you want easily with the data model browser module.
ERBuilder provides a data model browser which is an exploration module build for a full and deep exploration of the data structure extracted from your databases.
ERBuilder Data Modeler is a GUI data modeling tool that allows you to visualize, design and model databases by using entity relationship diagrams and automatically generates the most popular SQL databases including Amazon Redshift. Generate and share the data Model documentation with your team. Optimize your data model by using advanced features such as test data generation, schema compare and schema synchronization. Try now ERBuilder for 15 days FREEDOWNLOAD NOW