数据仓库服务 GaussDB(DWS)-PG_TABLES:应用示例

时间:2025-02-12 15:04:48

应用示例

查询指定模式下所有的表。

 1 2 3 4 5 6 7 8 910111213
SELECT tablename FROM PG_TABLES WHERE schemaname = 'myschema';   tablename---------------- inventory product sales_info test1 mytable product_info customer_info newproducts customer_t1(9 rows)
support.huaweicloud.com/devg-dws/dws_04_0784.html