Feedback-ID: i76984098:Fastmail
Message-ID: <433c2d5f-8e09-4128-b21e-558741ae8530@aklaver.com>
Date: Fri, 19 Jun 2026 07:50:10 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: can a linux program, running on the client side, generate data to
 load a temp table ?
From: Adrian Klaver <adrian.klaver@aklaver.com>
To: dfgpostgres <dfgpostgres3@gmail.com>, tgl@sss.pgh.pa.us
Cc: pgsql-general@postgresql.org
References: 
 <CAAcmDX9-tCLi72BwpAgxXsM9tr4foPbYouMr_cTyFYKU0XXyxQ@mail.gmail.com>
 <cd3d8e31-b060-4805-819f-f9d434c8a241@aklaver.com>
 <CAAcmDX_rLTkONAR_eGJcoWzzv0UvM5gr7hvo=qeWfw2Q3YZvrw@mail.gmail.com>
 <3efe0707-d61b-4182-80c8-4c68e723418a@aklaver.com>
Content-Language: en-US
In-Reply-To: <3efe0707-d61b-4182-80c8-4c68e723418a@aklaver.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/433c2d5f-8e09-4128-b21e-558741ae8530%40aklaver.com>
Precedence: bulk

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
adrian.klaver@aklaver.com