INSERT UNIQUE row?

From: pf(at)pfortin(dot)com
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: INSERT UNIQUE row?
Date: 2023-07-09 22:58:07
Message-ID: 20230709185807.1bc9afd9.pfortin@pfortin.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christophe Pettus 2023-07-09 23:02:14 Re: INSERT UNIQUE row?
Previous Message Adrian Klaver 2023-07-09 21:21:22 Re: How to add function schema in search_path in option definitio