On Monday 20 November 2006 12:13 pm, Wm.A.Stafford wrote: > I hope the subject says it all. I'm porting an Oracle-centric > application to PostgreSQL and the Oracle sql is full of the 'unique' > qualifier. I'm assuming PostgreSQL does not support 'unique' since > don't see a 'unique' anywhere in the PostgreSQL docs. Is there a > substitute or a technique to get the same result? > > Thanks, > -=bill stafford > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster Two places I found to specify a unique constraint. http://www.postgresql.org/docs/8.1/interactive/sql-createtable.html http://www.postgresql.org/docs/8.1/interactive/sql-createindex.htm -- Adrian Klaver aklaver@xxxxxxxxxxx
