Insert data if it is not existing

From: tango ward <tangoward15(at)gmail(dot)com>
To: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Insert data if it is not existing
Date: 2018-05-23 09:03:37
Message-ID: CAA6wQL+TssWQBKuysQWwOK6ggZ5niLiRXhHbZt8hZTC+qsfwXQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message a 2018-05-23 09:42:31 How do I select composite array element that satisfy specific conditions.
Previous Message a 2018-05-23 08:47:25 Re: How do I copy an element of composite type array into csv file?