Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1waNX8-001l4v-1G
	for pgsql-general@arkaria.postgresql.org;
	Fri, 19 Jun 2026 00:56:34 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.96)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1waNX7-00ERkY-08
	for pgsql-general@arkaria.postgresql.org;
	Fri, 19 Jun 2026 00:56:33 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1waNX6-00ERkP-2H
	for pgsql-general@lists.postgresql.org;
	Fri, 19 Jun 2026 00:56:32 +0000
Received: from sss.pgh.pa.us ([68.162.161.243])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.98.2)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1waNX4-000000013uv-2k0k
	for pgsql-general@postgresql.org;
	Fri, 19 Jun 2026 00:56:31 +0000
Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1])
	by sss.pgh.pa.us (8.18.1/8.18.1) with ESMTP id 65J0uS731412984;
	Thu, 18 Jun 2026 20:56:28 -0400
From: Tom Lane <tgl@sss.pgh.pa.us>
To: dfgpostgres <dfgpostgres3@gmail.com>
cc: pgsql-general@postgresql.org
Subject: Re: can a linux program, running on the client side,
 generate data to load a temp table ?
In-reply-to: 
 <CAAcmDX9-tCLi72BwpAgxXsM9tr4foPbYouMr_cTyFYKU0XXyxQ@mail.gmail.com>
References: 
 <CAAcmDX9-tCLi72BwpAgxXsM9tr4foPbYouMr_cTyFYKU0XXyxQ@mail.gmail.com>
Comments: In-reply-to dfgpostgres <dfgpostgres3@gmail.com>
	message dated "Thu, 18 Jun 2026 20:51:36 -0400"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <1412982.1781830588.1@sss.pgh.pa.us>
Date: Thu, 18 Jun 2026 20:56:28 -0400
Message-ID: <1412983.1781830588@sss.pgh.pa.us>
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: 
 <https://www.postgresql.org/message-id/1412983.1781830588%40sss.pgh.pa.us>
Precedence: bulk

dfgpostgres <dfgpostgres3@gmail.com> writes:
> 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).

psql's "\copy ... from program" might help you.  That just addresses
the data transfer though, the other logic will need to be implemented
client-side as well.

			regards, tom lane