Try
select oid,typname from pg_type;
after that
select oid, * from pg_type where ....
to select what you want.
Andrzej
> -----Original Message-----
> From: De Moudt Walter [SMTP:wdemoudt@planetinternet.be]
> Sent: 10 listopada 1999 21:00
> To: Edouard DESSIOUX; psql-general
> Subject: Re: [GENERAL] Types available
>
> try the following table : pg_opclass
>
> Edouard DESSIOUX wrote:
> >
> > Does anyone know which query (with
> > system tables) could give me all the
> > available type.
> >
> > Txs.
> > --
> > Edouard DESSIOUX
> > Proverbe chien :
> > "Si ca se mange pas,
> > Si ca se baise pas,
> > Pisse dessus !!"
> >
> > ************
>
> ************