| 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
| 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 |