Postgres Pro
Downloads
Home   >   mailing lists

Re: Data type OIDs - Mailing list pgsql-novice

From Thom Brown
Subject Re: Data type OIDs
Date
Msg-id AANLkTilgGg3XFgSYB3zm3GrWxdCSGdYGz9fdHE_Aj1h7@mail.gmail.com
Whole thread Raw
In response to Data type OIDs  (Greg <grigorey@yahoo.co.uk>)
Responses Re: Data type OIDs
List pgsql-novice
Tree view
On 6 July 2010 23:12, Greg <grigorey@yahoo.co.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

pgsql-novice by date:

Previous
From: Greg
Date:
Subject: Data type OIDs
Next
From: "John T. Dow"
Date:
Subject: Dropped table, no backup, restore from file system backup or WAL files?