vpruthi/doc-exports
1
0
Fork 0
forked from docs/doc-exports
Code Pull Requests Activity
doc-exports/docs/dws/umn/dws_03_0079.html
Lu, Huayi c5fcb46315 DWS UMN 801 version 
Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com>
Co-authored-by: Lu, Huayi <luhuayi@huawei.com>
Co-committed-by: Lu, Huayi <luhuayi@huawei.com>
2022-12-13 12:47:57 +00:00

1.1 KiB
Raw Permalink Blame History

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" in the Developer Guide.

Parent topic: Database Usage