Received: from ajax2.sovam.com (ajax2.sovam.com [194.67.1.173]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f9Q8DeP21198 for ; Fri, 26 Oct 2001 04:13:40 -0400 (EDT) (envelope-from dmitry@taurussoft.org) Received: from pm14-a29.dial.sovam.com ([195.218.132.29]:4569 "HELO hq.taurussoft.org" ident: "TIMEDOUT2" whoson: "tttt@online.ru" smtp-auth: TLS-CIPHER: TLS-PEER: ) by ajax2.sovam.com with SMTP id convert rfc822-to-8bit; Fri, 26 Oct 2001 12:13:15 +0400 Received: (qmail 21470 invoked from network); 26 Oct 2001 06:58:26 -0000 Received: from flame-in-night.hq.taurussoft.org (192.168.107.1) by kitezh.hq.taurussoft.org with SMTP; 26 Oct 2001 06:58:26 -0000 Received: (qmail 1652 invoked from network); 26 Oct 2001 06:58:06 -0000 Received: from localhost (127.0.0.1) by localhost with SMTP; 26 Oct 2001 06:58:06 -0000 Subject: Re: GUID in postgres From: "Dmitry G. Mastrukov" =?koi8-r?Q?=E4=CD=C9=D4=D2=C9=CA_?= =?koi8-r?Q?=E7=C5=CE=CE=C1=C4=D8=C5=D7=C9=DE_?= =?koi8-r?Q?=ED=C1=D3=D4=D2=C0=CB=CF=D7?= To: Dinesh Parikh Cc: pgsql-sql@postgresql.org In-Reply-To: <002701c15c50$8e6dbca0$f005a8c0@dinesh> References: <002701c15c50$8e6dbca0$f005a8c0@dinesh> Content-Type: text/plain; charset=KOI8-R Content-Transfer-Encoding: 8BIT X-Mailer: Evolution/0.15 (Preview Release) Message-Id: <1004078745.1363.5.camel@flame-in-night> Mime-Version: 1.0 X-Mailer: Evolution/0.15 (Preview Release) Date: 26 Oct 2001 10:57:36 +0400 X-Archive-Number: 200110/368 X-Sequence-Number: 5321 On óÒÄ, 2001-10-24 at 09:55, Dinesh Parikh wrote: > Hi, > Is there any concept of sys_Guid in postgres. > If yes what is that ?? > As i am using GUID in sql and oracle, then what is counterpart of this in postgres. It is urgent. > > Thanks in advance > Bye > Dinesh Parikh > Look at http://www.taurussoft.org/files/uniqueidentifier-0.1.9.tar.gz It uses libuuid from e2fsprogs to deal with UUIDs (GUIDs). Regards, Dmitry