Re: Data type OIDs

From: Thom Brown <thombrown(at)gmail(dot)com>
To: Greg <grigorey(at)yahoo(dot)co(dot)uk>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Data type OIDs
Date: 2010-07-06 22:15:37
Message-ID: AANLkTilgGg3XFgSYB3zm3GrWxdCSGdYGz9fdHE_Aj1h7@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On 6 July 2010 23:12, Greg <grigorey(at)yahoo(dot)co(dot)uk> wrote:

> Hi all, just a very quick question: Does OID of each data type stays the
> same in any installation of PostgreSql and when database is used e.g. OID
> for data type "bool" is 16, "char" is 18 etc. Or is the case that this
> identifiers can change?
>
> Thanks!
>
>
I'm worried that the reason that you're asking is because you wish to use
the oids elsewhere. Don't rely on oids. Those are for internal use only.
Have a look at pg_type for information on data types.

Why exactly are you asking? What are you trying to do?

Thom

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message John T. Dow 2010-07-07 01:24:56 Dropped table, no backup, restore from file system backup or WAL files?
Previous Message Greg 2010-07-06 22:12:27 Data type OIDs