Help Center> Data Warehouse Service> FAQs> Database Usage> How Can I Export All Tables and Views from a Database?
View PDF

How Can I Export All Tables and Views from a Database?

You can use pg_tables and pg_views to query all table information and views in a database. Example:

SELECT * FROM pg_tables;
SELECT * FROM pg_views;

For details about the returned columns, see PG_TABLES and PG_VIEWS.

Parent topic: Database Usage