David G. Johnston wrote: > > and what happens to this data after completion of the transaction ? > > > > Your choice. See “on conflict” clause of create temp table command. You mean the ON COMMIT clause. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com