MIME-Version: 1.0
References: 
 <CAAcmDX9-tCLi72BwpAgxXsM9tr4foPbYouMr_cTyFYKU0XXyxQ@mail.gmail.com>
 <cd3d8e31-b060-4805-819f-f9d434c8a241@aklaver.com>
In-Reply-To: <cd3d8e31-b060-4805-819f-f9d434c8a241@aklaver.com>
From: dfgpostgres <dfgpostgres3@gmail.com>
Date: Fri, 19 Jun 2026 10:38:25 -0400
Message-ID: 
 <CAAcmDX_rLTkONAR_eGJcoWzzv0UvM5gr7hvo=qeWfw2Q3YZvrw@mail.gmail.com>
Subject: Re: can a linux program, running on the client side, generate data to
 load a temp table ?
To: Adrian Klaver <adrian.klaver@aklaver.com>, tgl@sss.pgh.pa.us
Cc: pgsql-general@postgresql.org
Content-Type: multipart/alternative; boundary="000000000000767ca106549c3f42"
Archived-At: 
 <https://www.postgresql.org/message-id/CAAcmDX_rLTkONAR_eGJcoWzzv0UvM5gr7hvo%3DqeWfw2Q3YZvrw%40mail.gmail.com>
Precedence: bulk

--000000000000767ca106549c3f42
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

>>  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=E2=80=AFPM Adrian Klaver <adrian.klaver@aklave=
r.com>
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 ru=
n
> > 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
> adrian.klaver@aklaver.com
>

--000000000000767ca106549c3f42
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">&gt;&gt;=C2=A0

psql&#39;s &quot;\copy ... from program&quot; might help you.=C2=A0<br>Ya, =
I&#39;ve used \copy for copying data in the past.=C2=A0 But if I&#39;m not =
mistaken, the &quot;\copy... from program&quot; runs on the server side.=C2=
=A0 If I&#39;m wrong about that, if there&#39;s a client side version of th=
is, I&#39;m all ears !=C2=A0 And FWIW, a future release that has this would=
 be great !<div><br></div><div>plperlu might work in this case.=C2=A0 I nee=
d the &quot;untrusted&quot; version because I need to dump a bytea blob out=
 to a file, unzip it, query it (it&#39;s a SQLite DB), use the results of t=
he query to load a temp table.=C2=A0 So I need to make system calls that wr=
ite to disk and run external programs.=C2=A0 I work in a large corp and mad=
e the request to get that up on a DB instance.=C2=A0 Thankfully, I already =
have a superuser role that might be allowed to execute the plperlu script.<=
/div><div><br></div><div>-dave</div></div><br><div class=3D"gmail_quote gma=
il_quote_container"><div dir=3D"ltr" class=3D"gmail_attr">On Thu, Jun 18, 2=
026 at 9:11=E2=80=AFPM Adrian Klaver &lt;<a href=3D"mailto:adrian.klaver@ak=
laver.com">adrian.klaver@aklaver.com</a>&gt; wrote:<br></div><blockquote cl=
ass=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid=
 rgb(204,204,204);padding-left:1ex">On 6/18/26 5:51 PM, dfgpostgres wrote:<=
br>
&gt; v15.5 on linux<br>
&gt; <br>
<br>
&gt; My question is about whether or not I can get something like this to r=
un <br>
&gt; on the client side (where the script can be found).<br>
<br>
pl/plperlu?:<br>
<br>
<a href=3D"https://www.postgresql.org/docs/current/plperl-trusted.html" rel=
=3D"noreferrer" target=3D"_blank">https://www.postgresql.org/docs/current/p=
lperl-trusted.html</a><br>
<br>
&gt; <br>
&gt; Thanks in Advance :-)<br>
&gt; <br>
&gt; <br>
<br>
<br>
-- <br>
Adrian Klaver<br>
<a href=3D"mailto:adrian.klaver@aklaver.com" target=3D"_blank">adrian.klave=
r@aklaver.com</a><br>
</blockquote></div>

--000000000000767ca106549c3f42--