question about information_schema

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: question about information_schema
Date: 2004-05-18 11:51:36
Message-ID: 1084881096.22882.130.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jan Wieck 2004-05-18 12:15:36 Re: add server include files to default installation?
Previous Message Magnus Hagander 2004-05-18 10:55:41 Re: Call for 7.5 feature completion