In response to Morris, Roy :
> Hi, it seems every time I install a new version of postgres I go through
> this same fight with trying to get UUID to install, Ugg! Anyway in this
test=# \i '/usr/share/postgresql/8.3/contrib/uuid-ossp.sql';
test=# select * from uuid_generate_v1();
uuid_generate_v1
--------------------------------------
b3a24ab0-ed4b-11dd-8593-00138f82c65e
(1 row)
version: 8.3.5
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net