Dave Cramer <pg(at)fastcrypt(dot)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