Postgres Pro
Downloads
Home   >   mailing lists

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 - Mailing list pgsql-general

From Alban Hertroys
Subject 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
Date
Msg-id CAF-3MvNmmKTn7+nho3qUvGzhB7xNdUV6jb5mZQFYBoBq4fAN=Q@mail.gmail.com
Whole thread Raw
In response to 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  (Khangelani Gama <kgama@argility.com>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: Khangelani Gama
Date:
Subject: 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
Next
From: Chris Curvey
Date:
Subject: 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