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?
Re: INSERT UNIQUE row?
Re: INSERT UNIQUE row?
List pgsql-general
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?