Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 29F7C4762DD for ; Thu, 30 May 2002 14:40:15 -0400 (EDT) Received: from leo.pcisys.net (leo.pcisys.net [207.76.102.240]) by postgresql.org (Postfix) with ESMTP id AC74E476438 for ; Thu, 30 May 2002 14:31:39 -0400 (EDT) Received: from [208.202.106.174] (moe1.meg106-174.cos.pcisys.net [208.202.106.174]) by leo.pcisys.net (8.12.1/8.12.1) via ESMTP id g4UIVdri003650 for ; Thu, 30 May 2002 12:31:39 -0600 (MDT) env-from (hierophant@pcisys.net) User-Agent: Microsoft-Outlook-Express-Macintosh-Edition/5.0.4 Date: Thu, 30 May 2002 12:31:38 -0600 Subject: Re: UUID/GUID information From: Keary Suska To: Postgres-PHP Message-ID: In-Reply-To: <35363AB30BF2D311B73C0050DAB989F063C1@SEAPDC01> Mime-version: 1.0 Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit X-Archive-Number: 200205/114 X-Sequence-Number: 1246 on 5/30/02 12:05 PM, Busby@pnts.com purportedly said: > Dear List, > I'm trying to migrate my MS-SQL(shit) to Postgre. My database > depends on having a uniqueidentifier for all objects stored. (20 or so > tables of these unique objects). In MS-SQL I can use this datatype called > "uniqueidentifier" to accomplish this. What would be a similar solution in > Postgre? I've looked on through the MAN pages and also scoured the net for > this info...I don't necessarly need a UUID like the MS one but some unique > way to identifiy each object. > > Thanks in advance for help Postgres has what it calls an "OID". This is a unique identifier for every object. If you choose to use this, be sure to read all the caveats relating to external use of OIDs. For instance, if you re-create the database (say from a backup or dump), the IODs will change. IIRC, you can control this by dumping/restoring OIDs in the executables. Keary Suska Esoteritech, Inc. "Leveraging Open Source for a better Internet"