Re: data integrity and inserts - Mailing list pgsql-general

From gnari
Subject Re: data integrity and inserts
Date
Msg-id 000701c4d7d2$a2df3e60$0100000a@wp2000
Whole thread Raw
In response to data integrity and inserts  (Scott Frankel <leknarf@pacbell.net>)
List pgsql-general
From: "Scott Frankel" <leknarf@pacbell.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




pgsql-general by date:

Previous
From: Scott Frankel
Date:
Subject: data integrity and inserts
Next
From: "Joshua D. Drake"
Date:
Subject: Re: data integrity and inserts