postgresql 返回

 PostgreSQL 使用 GetTableInfoList  查询不到分区表(查不出分区表继承的主表)。

具体跟踪出来的sql 为下

select cast(relname as varchar) as Name,

                        cast(obj_description(c.oid,'pg_class') as varchar) as Description from pg_class c 

                         inner join 

pg_namespace n on n.oid = c.relnamespace and nspname='public'

                         inner join 

                         pg_tables z on z.tablename=c.relname

                        where  relkind = 'r' and relname

not like 'pg_%' and relname not like 'sql_%' and schemaname='public' order by relname

relkind = 'r' 改为 relkind = 'p'   才可以查出分区表