Re: PostgreSQL equivalent of the Oracale 'unique' qualifier - Mailing list pgsql-general

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@comcast.net