> how can i add *only* nonexisting entries to my db
> tables (iow, if it is one of the 100+ there now, i
> don't want to mess with it)?
I will take a stab at the easy question. Out of test solutions, this is the one that I know.
1. create a temp table using destination table schema using the LIKE clause.
http://www.postgresql.org/docs/8.1/interactive/sql-createtable.html
2. import external data into the temp table.
3. select into destinationtable from temptable where temptable.primarykey not exists
( select destinationtable.primarykey
from destination table
);
> also, how do i update multiple tables with related
> info? do i create a view and then copy to the view?
>
> will that automatically update the tables?