Dave Cramer <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org