public inbox for [email protected]  

help / color / mirror / Atom feed

From: dfgpostgres <[email protected]>
To: Adrian Klaver <[email protected]>
To: [email protected]
Cc: [email protected]
Subject: Re: can a linux program, running on the client side, generate data to load a temp table ?
Date: Fri, 19 Jun 2026 10:38:25 -0400
Message-ID: <CAAcmDX_rLTkONAR_eGJcoWzzv0UvM5gr7hvo=qeWfw2Q3YZvrw@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CAAcmDX9-tCLi72BwpAgxXsM9tr4foPbYouMr_cTyFYKU0XXyxQ@mail.gmail.com>
	<[email protected]>

>>  psql's "\copy ... from program" might help you.
Ya, I've used \copy for copying data in the past.  But if I'm not mistaken,
the "\copy... from program" runs on the server side.  If I'm wrong about
that, if there's a client side version of this, I'm all ears !  And FWIW, a
future release that has this would be great !

plperlu might work in this case.  I need the "untrusted" version because I
need to dump a bytea blob out to a file, unzip it, query it (it's a SQLite
DB), use the results of the query to load a temp table.  So I need to make
system calls that write to disk and run external programs.  I work in a
large corp and made the request to get that up on a DB instance.
Thankfully, I already have a superuser role that might be allowed to
execute the plperlu script.

-dave

On Thu, Jun 18, 2026 at 9:11 PM Adrian Klaver <[email protected]>
wrote:

> On 6/18/26 5:51 PM, dfgpostgres wrote:
> > v15.5 on linux
> >
>
> > My question is about whether or not I can get something like this to run
> > on the client side (where the script can be found).
>
> pl/plperlu?:
>
> https://www.postgresql.org/docs/current/plperl-trusted.html
>
> >
> > Thanks in Advance :-)
> >
> >
>
>
> --
> Adrian Klaver
> [email protected]
>

view thread (6+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: can a linux program, running on the client side, generate data to load a temp table ?
  In-Reply-To: <CAAcmDX_rLTkONAR_eGJcoWzzv0UvM5gr7hvo=qeWfw2Q3YZvrw@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox