[HACKERS] question about information_schema

2004-05-18 Thread Dave Cramer
I'm trying to implement getUDT for the jdbc driver. It requires the basetype of a type. If I do create type testint8 as (i int8) and then select typbasetype from pg_type where typname='testint8' the value is 0? While I'm asking how can I find all of the user defined types, assuming that the

Re: [HACKERS] question about information_schema

2004-05-18 Thread Kris Jurka
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;

Re: [HACKERS] question about information_schema

2004-05-18 Thread Tom Lane
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