Re: can a linux program, running on the client side, generate data to load a temp table ?

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(dot)klaver(at)aklaver(dot)com