Re: Copying records from TABLE_A to TABLE_B (in the same database)

[Rob Sargent]

Logical replication might be another option.
Although I am not sure if that is even possible inside
the samme database.
I know it's tricky inside the same server
(between different databases)



If you can get outside sql, the bulk copy facilities (CopyManager in 
java) is blindingly fast for me.

??

I meant using tools other than sql (and psql).   I have java code using 
org.postgresql.copy package because straight insert was too slow for 
large numbers of rows.