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

时间:2023-11-11 15:05:04

应用示例

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

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
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