Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id D16DE47734D
	for <pgsql-interfaces@postgresql.org>;
	Fri,  4 Oct 2002 10:12:19 -0400 (EDT)
Received: from sss.pgh.pa.us (unknown [192.204.191.242])
	by postgresql.org (Postfix) with ESMTP id F0522477435
	for <pgsql-interfaces@postgresql.org>;
	Fri,  4 Oct 2002 10:05:49 -0400 (EDT)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.12.5/8.12.5) with ESMTP id g94E5ohR020299;
	Fri, 4 Oct 2002 10:05:50 -0400 (EDT)
To: "Vilson farias" <vilson.farias@digitro.com.br>
Cc: pgsql-interfaces@postgresql.org,
	"IORRANA,     Maria Ribeiro" <iorrana.ribeiro@digitro.com.br>
Subject: Re: Postgres Object Identifiers 
In-reply-to: <00ce01c26ba2$1e37c2c0$98a0a8c0@dgtac> 
References: <00ce01c26ba2$1e37c2c0$98a0a8c0@dgtac>
Comments: In-reply-to "Vilson farias" <vilson.farias@digitro.com.br>
	message dated "Fri, 04 Oct 2002 09:32:31 -0300"
Date: Fri, 04 Oct 2002 10:05:50 -0400
Message-ID: <20298.1033740350@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200210/8
X-Sequence-Number: 3170

"Vilson farias" <vilson.farias@digitro.com.br> writes:
> So, somebody of you knows where can I get the description list of the types
> used by Postgres and their object identifers ?

	SELECT oid, typname FROM pg_type;

			regards, tom lane