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 <robjsarg...@gmail.com> 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
