Insert data if it is not existing - Mailing list pgsql-general

From tango ward
Subject Insert data if it is not existing
Date
Msg-id CAA6wQL+TssWQBKuysQWwOK6ggZ5niLiRXhHbZt8hZTC+qsfwXQ@mail.gmail.com
Whole thread Raw
Responses RE: Insert data if it is not existing
Re: Insert data if it is not existing
List pgsql-general

Hi,

I just want to ask if it's possible to insert data if it's not existing yet. I was able to play around with UPSERT before but that was when there was an error for duplicate data. In my scenario, no error message is showing.


Any suggestion?


Thanks,
J

pgsql-general by date:

Previous
From: "a"
Date:
Subject: Re: How do I copy an element of composite type array into csv file?
Next
From: "a"
Date:
Subject: How do I select composite array element that satisfy specific conditions.