Re: Postgres Analog of Oracle APPEND hint

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Postgres Analog of Oracle APPEND hint
Date: 2021-02-25 16:40:42
Message-ID: 75ea4d00-dbc6-93e1-3bee-b2e63d100243@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2/25/21 9:26 AM, Rumpi Gravenstein wrote:
> Unfortunately, I am not looking to load from an external source.  My
> process is moving data from source PostgreSQL tables to target
> PostgreSQL tables.
>
Are you trying to duplicate the source tables in the target tables? If
so, there are replication tools for this. If not, temporary tables in
the target db (possible loaded with copy) and smallish batches of
inserts from those to target might be an option.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jonathan Amsterdam 2021-02-25 17:50:05 serializability and unique constraint violations
Previous Message Tom Lane 2021-02-25 16:34:46 Re: Postgres Analog of Oracle APPEND hint