SELECT tablename FROM pg_tables T inner JOIN pg_class C on T.tablename = C.relname WHERE T.schemaname = ‘名称’ and C.relispartition = ‘f’;
pgsql查找没有分区的表名
最新推荐文章于 2022-07-28 20:56:09 发布
SELECT tablename FROM pg_tables T inner JOIN pg_class C on T.tablename = C.relname WHERE T.schemaname = ‘名称’ and C.relispartition = ‘f’;