Search Postgresql Archives

Re: PostgreSQL equivalent of the Oracale 'unique'

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Mon, 2006-11-20 at 15:13 -0500, 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?
> 

You mean a UNIQUE index on a column?

http://www.postgresql.org/docs/8.1/static/sql-createtable.html
http://www.postgresql.org/docs/8.1/static/sql-createindex.html

The postgresql docs are filled with the word "UNIQUE".

Regards,
	Jeff Davis



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux