Home > mailing lists

pg_restore without dropping db/table - Mailing list pgsql-general

From	anj patnaik
Subject	pg_restore without dropping db/table
Date	March 10, 2016 20:26:43
Msg-id	CAEQKwSmA-=vcAfuUE6=RLsiDt=qJiowwf_3CP8ntEKUPvXfMkQ@mail.gmail.com Whole thread Raw
Responses	Re: pg_restore without dropping db/table (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
List	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.

From: rob stone
Date: 10 March 2016, 20:20:18
Subject: Re: Plan to support predicate push-down into subqueries with aggregates?

From: Karsten Hilbert
Date: 10 March 2016, 20:41:10
Subject: Re: pg_restore without dropping db/table