[ https://issues.redhat.com/browse/TEIID-5963?page=com.atlassian.jira.plugi... ] Renat Eskenin edited comment on TEIID-5963 at 6/2/20 4:21 AM: -------------------------------------------------------------- This SQL get all metadata from DB: {code} select t.typname, t.oid from pg_catalog.pg_type t join pg_catalog.pg_namespace n on (t.typnamespace = n.oid) where n.nspname != 'pg_toast' and (t.typrelid = 0 or ( select c.relkind = 'c' from pg_catalog.pg_class c where c.oid = t.typrelid)) {code} We get all tausents of types from all schemas. was (Author: i3draven): This SQL get all metadata from DB: {code} select t.typname, t.oid from pg_catalog.pg_type t join pg_catalog.pg_namespace n on (t.typnamespace = n.oid) where n.nspname != 'pg_toast' and (t.typrelid = 0 or ( select c.relkind = 'c' from pg_catalog.pg_class c where c.oid = t.typrelid)) {code} -- This message was sent by Atlassian Jira (v7.13.8#713008)