Received: from localhost (unknown [200.46.204.183])
	by developer.postgresql.org (Postfix) with ESMTP id 6602E2E0085
	for <pgsql-admin-postgresql.org@developer.postgresql.org>;
	Wed, 11 Jun 2008 19:56:00 -0300 (ADT)
Received: from developer.postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 73678-01
	for <pgsql-admin-postgresql.org@developer.postgresql.org>;
	Wed, 11 Jun 2008 19:55:47 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from web90321.mail.mud.yahoo.com (web90306.mail.mud.yahoo.com
	[216.252.100.143])
	by developer.postgresql.org (Postfix) with SMTP id DA4442E0093
	for <pgsql-admin@postgresql.org>; Wed, 11 Jun 2008 19:55:14 -0300 (ADT)
Received: (qmail 26563 invoked by uid 60001); 11 Jun 2008 22:55:12 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type:Message-ID;
	b=dEKNSy1mmE40ESnbXq4ai0M53gpmlTO6tGE1ZywVZDRkR7eU4+MhO6xZx/dSeB6zYlVrawl8bJ+oES7IYkjVkERD+vKXuXWU+bjqOWoxbCvZkN7JEO+ZAnzNy9MckfsGkv6QUNRzVpM4OrRKVvNuLSklpincNbp6uvOIOHwrehA=;
Received: from [89.32.164.144] by web90306.mail.mud.yahoo.com via HTTP;
	Wed, 11 Jun 2008 15:55:12 PDT
X-Mailer: YahooMailRC/975.45 YahooMailWebService/0.7.199
Date: Wed, 11 Jun 2008 15:55:12 -0700 (PDT)
From: Dombi Attila <dombi_attila@yahoo.com>
Subject: Data Type Conversion, get simple data types
To: pgsql-admin@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1817372012-1213224912=:25680"
Message-ID: <233932.25680.qm@web90306.mail.mud.yahoo.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200806/103
X-Sequence-Number: 29441

--0-1817372012-1213224912=:25680
Content-Type: text/plain; charset=us-ascii

Hi ,


I want to get the colum types in postgres, and i received a lot of customized data types,
like bpchar, oid etc. My problem is, i want to represent these rows in a Java table, and i need to know,
the the basic datatypes of the columns, beacuse i want to use that column types in the table to make updates in the database.
So how can i get the basic datatypes of the columns, or how can i simplify the customized data types?

                       With thanks,
                                    Dombi Attila



      
--0-1817372012-1213224912=:25680
Content-Type: text/html; charset=us-ascii

<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman, new york, times, serif;font-size:12pt"><div>Hi ,<br><br><br>I want to get the colum types in postgres, and i received a lot of customized data types,<br>like bpchar, oid etc. My problem is, i want to represent these rows in a Java table, and i need to know,<br>the the basic datatypes of the columns, beacuse i want to use that column types in the table to make updates in the database.<br>So how can i get the basic datatypes of the columns, or how can i simplify the customized data types?<br><br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;  &nbsp;&nbsp;  &nbsp;&nbsp;  &nbsp;&nbsp;  &nbsp;&nbsp; With thanks,<br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;  &nbsp;&nbsp;  &nbsp;&nbsp;  &nbsp;&nbsp;  &nbsp;&nbsp;  &nbsp;&nbsp;  &nbsp;&nbsp;  &nbsp;&nbsp;  Dombi Attila<br></div></div><br>



      </body></html>
--0-1817372012-1213224912=:25680--