uniqueidentifier

I can't help you with a Postgres equivalent for the uniqueidentifier datatype. However, when it comes to migrating your existing data the binary type migration is not very straightforward. I'm not even sure that uniqueidentifier IS a binary type....it's hard to tell exactly from the SQL Books Online. But if you get to that point and you've got problems, drop me an email and I'll tell you how I migrated VARBINARY data from MSSQL to Postgres.

Roman Fail
Sr. Web Application Developer
POS Portal, Inc.

-----Original Message-----
From: Mark Leicester [mailto:mark(dot)leicester(at)energyintellect(dot)com]
Sent: Wed 1/15/2003 10:01 PM
To: pgsql-general(at)postgresql(dot)org
Cc:
Subject: <no subject>

Hi there,
I've successfully installed Postgres 7.3.1 on MAC OS X 10.2.3 and am keen to
get started porting some MSSQL databases to Postgres.
The problem I have struck is that there is no equivalent to MSSQL's
uniqueidentifier datatype in Postgres.
I have seen the implementation for Linux at http://www.taurussoft.org/ but
that relies on the e2fs libraries for uuid generation.
Has anyone ported the uniqueidentifier for the Mac, or can anyone give me
tips on plugging the linux implementation into the mac uuid libraries.
Thanks in advance,
Mark.