Postgres Pro
Downloads
Home   >   mailing lists

INSERT UNIQUE row? - Mailing list pgsql-general

From pf@pfortin.com
Subject INSERT UNIQUE row?
Date
Msg-id 20230709185807.1bc9afd9.pfortin@pfortin.com
Whole thread Raw
Responses Re: INSERT UNIQUE row?  (Christophe Pettus <xof@thebuild.com>)
Re: INSERT UNIQUE row?  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: INSERT UNIQUE row?  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view 
Hi,

Trying to figure out how to insert new property addresses into an
existing table.

Can a UNIQUE constraint be applied to an entire row?  Adding UNIQUE to
each column won't work in such a case since there are multiple properties
* on the same street
* in the same town
* with the same number on different streets
* etc...

Each row is only unique as an entity; but the columns are not...  

Is this covered in the docs?

Thanks,
Pierre

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: How to add function schema in search_path in option definitio
Next
From: Christophe Pettus
Date:
Subject: Re: INSERT UNIQUE row?