UNIQUE index: http://www.postgresql.org/files/documentation/books/aw_pgsql/node108.htm l UNIQUE constraint: http://www.postgresql.org/files/documentation/books/aw_pgsql/node129.htm l Online manual information: http://www.postgresql.org/docs/8.2/interactive/ddl-constraints.html#AEN2 058 http://www.postgresql.org/docs/8.2/interactive/indexes-unique.html There is a little search box in the upper right hand corner that might prove helpful for your cause. > -----Original Message----- > From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general- > owner@xxxxxxxxxxxxxx] On Behalf Of Wm.A.Stafford > Sent: Monday, November 20, 2006 12:13 PM > To: pgsql-general@xxxxxxxxxxxxxx > Subject: [GENERAL] PostgreSQL equivalent of the Oracale 'unique' qualifier > > 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
