Postgres Pro
Downloads
Home   >   mailing lists

Re: how to merge a table from another DB - Mailing list pgsql-general

From Mike Nolan
Subject Re: how to merge a table from another DB
Date
Msg-id 200402172016.i1HKGdAI032393@gw.tssi.com
Whole thread Raw
In response to how to merge a table from another DB  ("Hought, Todd" <Todd.Hought@echostar.com>)
List pgsql-general
Tree view 
> the forked db can be merged back in to the live one. A change to one
> column of every row in a certain table. How can I update just that field
> in every row of the db without harming the existing data already in that
> table?

Would something like this work?

    UPDATE table1
    set table1.columna = table2.columna
    from table2
    where table1.keyfield = table2.keyfield;
--
Mike Nolan

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: String manipulation
Next
From: Bruno Wolff III
Date:
Subject: Re: how to merge a table from another DB