Using COPY via pg_background extension

From: "Oleg Dushin" <oleg(dot)dushin(at)pbs-software(dot)com>
To: <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Using COPY via pg_background extension
Date: 2026-02-24 16:13:15
Message-ID: 001901dca5a8$6fdc2760$4f947620$@pbs-software.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello everyone,

I couldn't find anything on this topic in the mailing lists or in the
documentation for the 'pg_background' extension.

https://github.com/vibhorkum/pg_background?tab=readme-ov-file#known-limitati
ons

Perhaps I overlooked something.

My question is: Is it possible to use the COPY protocol in combination with
pg_background?

More specifically, is it possible to load data from a file into a table via
background worker process?

COPY country FROM '/usr1/proj/bray/sql/country_data';

Would the following call or something similar be possible and achieve the
desired result??

pg_background_launch_v2('COPY country FROM
'/usr1/proj/bray/sql/country_data');

https://www.postgresql.org/docs/current/sql-copy.html

Kind regards,

Oleg

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2026-02-24 16:28:20 Re: Using COPY via pg_background extension
Previous Message Adrian Klaver 2026-02-24 15:50:33 Re: Recovery Verification