question about information_schema - Mailing list pgsql-hackers

From Dave Cramer
Subject question about information_schema
Date
Msg-id 1084881096.22882.130.camel@localhost.localdomain
Whole thread Raw
Responses Re: question about information_schema  (Kris Jurka <books@ejurka.com>)
Re: question about information_schema  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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 user is the owner of the cluster. I see that pg_dump can do
this ?

-- 
Dave Cramer
519 939 0336
ICQ # 14675561



pgsql-hackers by date:

Previous
From: "Magnus Hagander"
Date:
Subject: Re: Call for 7.5 feature completion
Next
From: Jan Wieck
Date:
Subject: Re: add server include files to default installation?