tuichenchuxin commented on issue #13571:
URL:
https://github.com/apache/shardingsphere/issues/13571#issuecomment-966936115
in pg this sql is not supported
```
SELECT c.oid,
n.nspname AS
schemaname,
c.relname AS
tablename,
c.relacl,
pg_get_userbyid(c.relowner) AS
tableowner,
obj_description(c.oid) AS
description,
c.relkind,
ci.relname As
cluster,
c.relhasoids AS
hasoids,
c.relhasindex AS
hasindexes,
c.relhasrules AS
hasrules,
t.spcname AS
tablespace,
c.reloptions AS
param,
c.relhastriggers AS
hastriggers,
c.relpersistence AS
unlogged,
ft.ftoptions,
fs.srvname,
c.reltuples,
((SELECT count(*) FROM pg_inherits WHERE inhparent = c.oid) > 0) AS
inhtable,
i2.nspname AS
inhschemaname,
i2.relname AS
inhtablename
FROM pg_class c
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_tablespace t ON t.oid = c.reltablespace
LEFT JOIN (pg_inherits i INNER JOIN pg_class c2 ON i.inhparent =
c2.oid LEFT JOIN pg_namespace n2 ON n2.oid = c2.relnamespace) i2
ON i2.inhrelid = c.oid
LEFT JOIN pg_index ind ON (ind.indrelid = c.oid) and
(ind.indisclustered = 't')
LEFT JOIN pg_class ci ON ci.oid = ind.indexrelid
LEFT JOIN pg_foreign_table ft ON ft.ftrelid = c.oid
LEFT JOIN pg_foreign_server fs ON ft.ftserver = fs.oid
WHERE ((c.relkind = 'r'::"char") OR (c.relkind = 'f'::"char"))
AND n.nspname = 'public'
ORDER BY schemaname, tablename;
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
