gauss/postgre根据表名查分区表

SELECT * from pg_partition
join  pg_class on pg_class.oid = pg_partition.parentid
where pg_class.relname = 'your_table'
ORDER BY pg_partition.relname
posted @ 2020-09-01 13:36  BigOrang  阅读(1443)  评论(0编辑  收藏  举报