pg_restore without dropping db/table

From: anj patnaik <patna73(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: pg_restore without dropping db/table
Date: 2016-03-10 15:51:05
Message-ID: CAEQKwSmA-=vcAfuUE6=RLsiDt=qJiowwf_3CP8ntEKUPvXfMkQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,
I've a database/table already with existing records.
I will then create a dump via pg_dump from another database and want to
restore into this first database.

I just want to update the existing db with any new rows.

Does pg_restore only add new rows if I restore without deleting old db?

Please advise.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message rob stone 2016-03-10 17:19:59 Re: Plan to support predicate push-down into subqueries with aggregates?
Previous Message Adrian Klaver 2016-03-10 14:02:29 Re: How to find configuration data in _PG_init()