On Thu, 16 Jan 2003, Mark Leicester wrote:
> 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,
Maybe it would be better if you told us what exactly you need of this
data type so those of us not familiar with MSSQL's uniqueidentifier data
type might make some suggestions for replacements. Do you need a unique
ID across multiple database servers / instances? within a single
database, etc...