question about information_schema

On Tue, 18 May 2004, Dave Cramer wrote:

If I do create type testint8 as (i int8) and then select typbasetype
from pg_type where typname='testint8' the value is 0?

You've created a complex type here, not a domain. See typtype and
typrelid for this case.

create domain testint8 as int8; will do what you were expecting.

Kris Jurka

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