Re: data integrity and inserts

From: "gnari" <gnari(at)simnet(dot)is>
To: <pgsql-general(at)postgresql(dot)org>, "Scott Frankel" <leknarf(at)pacbell(dot)net>
Subject: Re: data integrity and inserts
Date: 2004-12-01 18:21:54
Message-ID: 000701c4d7d2$a2df3e60$0100000a@wp2000
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

From: "Scott Frankel" <leknarf(at)pacbell(dot)net>

>
> I want to ensure data integrity when inserting into a table, preventing
> multiple
> entries of identical rows of data.
>
> sample table:
>
> CREATE TABLE names (the_id SERIAL PRIMARY KEY, the_name text);

sounds like a job for a UNIQUE constraint

gnari

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Woodchuck Bill 2004-12-01 18:25:53 Re: Upcoming Changes to News Server ...
Previous Message Joshua D. Drake 2004-12-01 18:21:29 Re: data integrity and inserts