Re: Check for duplicates before inserting new rows

I would suggest creating a temp table based on the original table and
loading the data into it first. You can then purge the duplicates.

George Woodring
iGLASS Networks
www.iglass.net

On Fri, Sep 4, 2020 at 9:21 AM Rich Shepard <rshepard(at)appl-ecosys(dot)com>
wrote:

> This is a new issue for me: I've received data from a different source and
> need to add non-duplicates to two tables in the database. Each row in the
> new data has a station ID and associated measurements.
>
> The existing database includes a table for station information and another
> for measurements made there.
>
> I want to learn which stations and which measurements in the new data set
> are not included in the existing tables. And, I don't want to try inserting
> the new data and have postgres tell me when it's found duplicates,
> especially since there are two tables involved.
>
> My research into how to do this has not found a solution so I ask for
> pointers to resources that will teach me how to add these new data to both
> tables.
>
> Regards,
>
> Rich
>
>
>
>