Re: Copy Data Question

> 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?