Google for 'postgresql uuid' will reveal some options. On Mon, Oct 17, 2005 at 09:03:17AM +0100, Paul Newman wrote: > Hi, > > We are using GUIDS as primary keys. At the moment we're using a varchar > 32. We'd like to use varchar 16 but had some problems with the generated > chars; we were using UNICODE locale (we're now using WIN1251). Should we > use bytea, retry varchar 16 (with the new local), or some other column > type ?? What is going to give us the best performance (with 8.1) ? > > > > Thank You > > > > Paul Newman > -- Jim C. Nasby, Sr. Engineering Consultant jnasby@xxxxxxxxxxxxx Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
