My use case involves complicated joins on source tables in one schema loading a target table in the same or a different schema.
On Thu, Feb 25, 2021 at 11:41 AM Rob Sargent <robjsargent@xxxxxxxxx> wrote:
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.
Rumpi Gravenstein
