Re: Synchronizing a table that is in two different databases : Need to dump a table as inserts from db1 and change the insert statements into UPDATE statements

On 28 March 2014 11:07, Khangelani Gama <kgama@argility.com> wrote:
> Hi Chris or anyone who can help
>
> When I try this just below, it complains about foo (new table created in
> db2) , saying ERROR: schema foo does not exist. I got stuck on this error
> for a while now but still trying to see why but still no luck so far. If you
> have something please help
>
> begin;
>
> update foo
> set br_desc = bar.br_desc
> , br_active = bar.br_active
> (rest of columns)
> where foo.br_cde = bar.br_cde;

Really? I would have expected ERROR: table or schema bar does not exist.

Look up the syntax for UPDATE FROM.