A very Strange SQL of PostgreSQL -


Our PostgreSQL server is a strange SQL in version 8.4. It looks like a system SQL which is excited by PG server! I do not have any information about this SQL? Does anyone know this?

- Select the weird SQL

  NULL TABLE_CAT, n.nspname as TABLE_SCHEM, in the form of c.relname TABLE_NAME, the form of the form n.nspname In ~ ^ ^ pg_ 'or N. Nspname = 'INFORMATION_SCHEMA' when true when n.nspname = 'pg_catalog' or n.nspname = 'INFORMATION_SCHEMA' then case c.relkind when 'r' then 'system table' when 'v' then 'system view' when 'I' then 'system index' balance zero end when n.nspname = 'pg_toast' then case c.relkind when 'r' then 'system toast table' when 'i' then 'system toast index' balance zero end and case c . When 'R' then 'floating table' when 'I' then 'temporary index' balance zero end END when false then case c.relkind when 'r' then 'table' when 'i' then 'index' when 's' Then 'SEQUENCE' when 'V' then pg_catalog.pg_namespace N, pg_catalog.pg_class G left the 'View' as the left commentary and zero end of TABLE_TYPE as the comment, d.description at pg_catalog.pg_description D (c. Og = d. Objoid and d.objsubid = 0) Add the left pg_catalog.pg_class DC current (d.classoid = dc.oid and dc .relname = 'pg_class'    < P> 

This is part of getTables ()



Comments