Thread: Data types

Data types

From
"Jonel Rienton"
Date:
Hi guys,

Does Postgres store all the possible column datatypes somewhere in its
system tables?  Like int8, int4, character varying, etc. I'm trying to write
another GUI client that can list all the database objects in Postgres.
Thanks.

Regards,

Jonel

--
I know not english well, but I know 9 computer languages.

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.371 / Virus Database: 267.14.9/217 - Release Date: 12/30/2005



Re: Data types

From
Michael Fuhr
Date:
On Fri, Dec 30, 2005 at 12:57:57PM -0600, Jonel Rienton wrote:
> Does Postgres store all the possible column datatypes somewhere in its
> system tables?  Like int8, int4, character varying, etc. I'm trying to write
> another GUI client that can list all the database objects in Postgres.

See "System Catalogs" in the documentation; here's a link to the
latest version:

http://www.postgresql.org/docs/8.1/interactive/catalogs.html

You might also want to check out the Information Schema, which is
defined in the SQL standard.

http://www.postgresql.org/docs/8.1/interactive/information-schema.html

--
Michael Fuhr

Re: Data types

From
James Cradock
Date:
Try pg_type. typname should give you what you're looking for.

On Dec 30, 2005, at 1:57 PM, Jonel Rienton wrote:

> Hi guys,
>
> Does Postgres store all the possible column datatypes somewhere in its
> system tables?  Like int8, int4, character varying, etc. I'm trying
> to write
> another GUI client that can list all the database objects in Postgres.
> Thanks.
>
> Regards,
>
> Jonel
>
> --
> I know not english well, but I know 9 computer languages.
>
> --
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.1.371 / Virus Database: 267.14.9/217 - Release Date:
> 12/30/2005
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>                http://archives.postgresql.org
>


Re: Data types

From
"Jonel Rienton"
Date:
Thank you gentlemen, this will keep me busy for a while.

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of James Cradock
Sent: Friday, December 30, 2005 1:05 PM
To: Jonel Rienton
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Data types

Try pg_type. typname should give you what you're looking for.

On Dec 30, 2005, at 1:57 PM, Jonel Rienton wrote:

> Hi guys,
>
> Does Postgres store all the possible column datatypes somewhere in its
> system tables?  Like int8, int4, character varying, etc. I'm trying to
> write another GUI client that can list all the database objects in
> Postgres.
> Thanks.
>
> Regards,
>
> Jonel
>
> --
> I know not english well, but I know 9 computer languages.
>
> --
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.1.371 / Virus Database: 267.14.9/217 - Release Date:
> 12/30/2005
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>                http://archives.postgresql.org
>


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@postgresql.org so that your
       message can get through to the mailing list cleanly

--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.371 / Virus Database: 267.14.9/217 - Release Date: 12/30/2005


--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.371 / Virus Database: 267.14.9/217 - Release Date: 12/30/2005