Re: question about information_schema - Mailing list pgsql-hackers

Dave Cramer <pg@fastcrypt.com> writes:
> While I'm asking how can I find all of the user defined types, assuming
> that the user is the owner of the cluster. I see that pg_dump can do
> this ?

IIRC, what pg_dump actually does is look for types that are not in the
pg_catalog schema.  Plus you probably want to exclude composite types
other than "standalone" ones (ie, all those whose associated pg_class
entry has a relkind other than COMPOSITE_TYPE).
        regards, tom lane