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