public inbox for [email protected]  

help / color / mirror / Atom feed

From: Adrian Klaver <[email protected]>
To: dfgpostgres <[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 07:50:10 -0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <CAAcmDX9-tCLi72BwpAgxXsM9tr4foPbYouMr_cTyFYKU0XXyxQ@mail.gmail.com>
	<[email protected]>
	<CAAcmDX_rLTkONAR_eGJcoWzzv0UvM5gr7hvo=qeWfw2Q3YZvrw@mail.gmail.com>
	<[email protected]>

On 6/19/26 7:48 AM, Adrian Klaver wrote:
> On 6/19/26 7:38 AM, dfgpostgres wrote:
>>  >> 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 !
> 
> It is client side, but is only available in the the psql client:
> 
> https://www.postgresql.org/docs/current/app-psql.html

Forgot to add to previous post:

"Performs a frontend (client) copy. This is an operation that runs an 
SQL COPY command, but instead of the server reading or writing the 
specified file, psql reads or writes the file and routes the data 
between the server and the local file system. This means that file 
accessibility and privileges are those of the local user, not the 
server, and no SQL superuser privileges are required."


> 
> 
> 


-- 
Adrian Klaver
[email protected]

view thread (6+ messages)

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: <[email protected]>

* 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