Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id F2977476355 for ; Thu, 30 May 2002 14:00:24 -0400 (EDT) Received: from seapdc01.PNTS (ip63.c216.blk1.bel.nwlink.com [209.20.216.63]) by postgresql.org (Postfix) with ESMTP id 65A114763C5 for ; Thu, 30 May 2002 13:51:23 -0400 (EDT) Received: by SEAPDC01 with Internet Mail Service (5.5.2653.19) id ; Thu, 30 May 2002 11:05:28 -0700 Message-ID: <35363AB30BF2D311B73C0050DAB989F063C1@SEAPDC01> From: David Busby To: "'pgsql-php@postgresql.org'" Subject: UUID/GUID information Date: Thu, 30 May 2002 11:05:18 -0700 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: text/plain X-Archive-Number: 200205/112 X-Sequence-Number: 1244 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 /B