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 ) id 1waaWA-001uVR-0R for pgsql-general@arkaria.postgresql.org; Fri, 19 Jun 2026 14:48:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1waaW9-00GgWR-0C for pgsql-general@arkaria.postgresql.org; Fri, 19 Jun 2026 14:48:25 +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 ) id 1waaW8-00GgWI-0a for pgsql-general@lists.postgresql.org; Fri, 19 Jun 2026 14:48:24 +0000 Received: from fhigh-a5-smtp.messagingengine.com ([103.168.172.156]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1waaW6-000000019dv-1MYC for pgsql-general@postgresql.org; Fri, 19 Jun 2026 14:48:23 +0000 Received: from phl-compute-04.internal (phl-compute-04.internal [10.202.2.44]) by mailfhigh.phl.internal (Postfix) with ESMTP id 6122314001E3; Fri, 19 Jun 2026 10:48:20 -0400 (EDT) Received: from phl-frontend-04 ([10.202.2.163]) by phl-compute-04.internal (MEProxy); Fri, 19 Jun 2026 10:48:20 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm3; t=1781880500; x=1781966900; bh=b1a0ZHjcXT47uc1fCDp9Td4frVci0huXM9TNdPKResc=; b= R6CT1SpB58yNdVQ50DO1zQrBHM8Ta9UuT+UKcN2tLwKYz90lESTzl0r0HzvaNSFV RKOgtx4T32wxIsFwIuJE9D8IJvoxVMblJn9bAcMO4yOGDHisaIBMIE706uYJefxC iJ8LkDqGA6CxSCZFqqcJlT6tAbXOYL/nNA37NB5+oPmDpTs2utSgB8D0eYLDrBqK ydVAyhO1OngHafkWh3oJyMr1cPubqeWXQyC8AmWzAK7vduV8XanNrjMmiyNQ5YJy AZoLWSjMko4qm3IIv6AXjJ7xO1Jge8dYMmsrcfiMt1du5g2xhRB9xUOLZ7o8ZR+Q yvH4/e2d94dRZqLy2YqJhw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t=1781880500; x= 1781966900; bh=b1a0ZHjcXT47uc1fCDp9Td4frVci0huXM9TNdPKResc=; b=c RykejRzbiS3x8iMQTKL6Xw/0xvFlES/rAH+MB271Twh4KwAmDRxrdLvX7J8sSQtM D6CKR2djlc5DKpEJbOmjG2U+lHjFVc/ZKvnHqlzQNDKVxBS33OC6LxiYmqByU77w DfVWbPaOokfQeNzMD3zIT72JqkTVKjs8KF84uoCWR5HHUeuPi4k/j1VY2O9rvgPD bZAlZn5m9n7S7Zio1agIR/a8pbyNx+47Qtd7lK6p+CT0hTI4BJ8eBN75ASq5Cccy iWknaWm27UfOA4Mhkvw+DNW58zu2YlnPhbOetpCWA6mIKyqXQqLpVzcMvXRGVv09 yXsNz/2IDCVMeWmVl4aGg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: dmFkZTE1toXr4aeBLoTE4JSLRe3MtbyD67s4Qk0Rv+Iu9NAkkfwRnun9kS9HLjm37rHWOM LUOFHrqKfvtlmiQDr03gtft8Z1CA17W8fkWbMeTvIamZJePNYsLIjMYIX/+U8RbsgsBobw fFFs7Yosnt3fmNu8MMYUEhrptFvO0R7ZNqjVYojuf1p7V5ujmgV3kx65Fr4oFXtyBqbxnl SPR6+4asvOSY8KEuzqgqLzKtQiuktq4TMwvEgX9GsW1msKJxlia0eV+i2Bw2dtoga7spOb RcjPSG7n/2ApQEDkRTOAJNVEh5Wwu/MHuaqDwwEudV6KCIdhYyjYPy/+kyLt1cyXZoBlXu Iw0K0fP0lrvcu21AzKG04qQcacU/oisiBgovoIFzH+MIN74HlpgtCaZJbC0rHWD9azlzZP CHGs5UmCvuGGESqtnSRUJInc4iNtf62Qtdj2ZOQrZ/Dwu2xYx0/6SH7NhIubF9B1QTRtLM hFiutYiJkomahQPPOv64freWjVqomwXJYb8VOIlr0UL49MLSXt2CSXiBzTyNWnfbWY5zxO GnG5qdH1d+jtOqoQDU5HlJy/UYt8HgxFRbpdEbTh+Nvh7AS24o/t5pJe8wmG4u5s+CiXOY tF7KUkzjZSotghl/cs902R+XNX5pb2m9/9lmsQ9zzMfggqnvhA3R/fjMS0Tw X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Fri, 19 Jun 2026 10:48:19 -0400 (EDT) Message-ID: <3efe0707-d61b-4182-80c8-4c68e723418a@aklaver.com> Date: Fri, 19 Jun 2026 07:48:19 -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 ? To: dfgpostgres , tgl@sss.pgh.pa.us Cc: pgsql-general@postgresql.org References: Content-Language: en-US From: Adrian Klaver In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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 -- Adrian Klaver adrian.klaver@aklaver.com