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.94.2) (envelope-from ) id 1sqhKw-00ByPe-Ve for pgsql-general@arkaria.postgresql.org; Tue, 17 Sep 2024 23:10:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sqhKv-00HTpQ-3g for pgsql-general@arkaria.postgresql.org; Tue, 17 Sep 2024 23:10:21 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sqhKu-00HTpI-Ld for pgsql-general@lists.postgresql.org; Tue, 17 Sep 2024 23:10:20 +0000 Received: from mail-yb1-xb2a.google.com ([2607:f8b0:4864:20::b2a]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sqhKr-001ikO-Dg for pgsql-general@lists.postgresql.org; Tue, 17 Sep 2024 23:10:20 +0000 Received: by mail-yb1-xb2a.google.com with SMTP id 3f1490d57ef6-dff1ccdc17bso6087669276.0 for ; Tue, 17 Sep 2024 16:10:18 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1726614617; x=1727219417; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=4IetDJet3moz8056QoYYzoYjdNkFQcMxICsJYWY8t4E=; b=IXMMLzEyOTpkHPH9wkBM5VgA+BgNxU+xsLildZwqrntQiPY+7KNiePPJ59E82Btk5k u10LIWyl9QLJrj9qW8fLK4R3zfgsh9XRu9BLwmf7RCTL52eAywEI2SpxwpALUly9Wb2h 5H2GmWWNXWTdHZDkPJbwcdHJvEVH0askhCnUIghm22xvp9vDag/GrI+TGPEinwstZhJh WyrhA92sof/0ADCVqVMCeZdMLW5FaqUST7kdcPJlM9kIFF/fMtJJ7k7u7kLX33fBFu+4 Rc93+5sH96z6mnFKlvbq4r6wH/P3mnUHdDdZz6YHdXr7cJdYxgUdtqoVU4QMSrTa1DDV Lpuw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1726614617; x=1727219417; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=4IetDJet3moz8056QoYYzoYjdNkFQcMxICsJYWY8t4E=; b=c2S5PjQ0KZ3E9oqTcRG/yQB37DK3j/SxL3GBcdzlIPwoNZrRV8oxJzlpGwk3jGY8T4 3rL0LAZuJTCG2iGNQhaTFjThe2NZDvojibGSlNIib03pu3PWFF71NJvyi9euUZ576U0Z pszxHji02MAnpFeKguQw+2ikMxW4DuTsjberaW0mnWivDbimpmPaMSDyVpFxZoR5E6x+ IljtUQQQrp/bQ1xayOa1zvcWP9LJPVCKjhlyxeWh8DgYibZzF/V9MbxDimQIc71TjoSy 5HrtJcCx8Id7BsFQwDbiWHMe1CcXqLxMwB3ke+JQAgbiZg6L3OP6KhQdpZ6O8z3WBiAC pR8Q== X-Forwarded-Encrypted: i=1; AJvYcCUg+jj4gRcqFnDO/Xtm741RZckgteXUHgKIQGqoAjSaxoRn4rqtVXpGduduCelgjlYLQG9+02YeuT5icnD2@lists.postgresql.org X-Gm-Message-State: AOJu0YzF3cdbCqcPjbd/hUYz0LTF/b6Q36oY9d2KsSVqj/OqWIETVb0r ak/MV4My+chRKSJrGmrHHBgZ/BOmISzBZuvsjqic4svs7xjHlktezm57fekV+sEOjRyfrQPdVxh cOIuLRl367RbKSxJhjXe/sa36Dnk= X-Google-Smtp-Source: AGHT+IEInj2xbSVl4U0gL1oULNgZzDY4Z7VZH0/6b5ksQurK7PfawRGqb25gV4rOLnOK3KyIo9eeCOZ/OfwCl6pOKlc= X-Received: by 2002:a05:6902:2e0f:b0:e1d:94cf:4922 with SMTP id 3f1490d57ef6-e1d9dbe2a60mr16525708276.33.1726614616727; Tue, 17 Sep 2024 16:10:16 -0700 (PDT) MIME-Version: 1.0 References: <0e48b60d-7beb-4f40-9de7-371710dd4d1b@aklaver.com> In-Reply-To: From: Andy Hartman Date: Tue, 17 Sep 2024 19:10:05 -0400 Message-ID: Subject: Re: load fom csv To: Rob Sargent Cc: Adrian Klaver , Muhammad Usman Khan , pgsql-general@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000e4ea73062258ca89" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000e4ea73062258ca89 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable I'll echo vars and see if something looks strange. THanks. On Tue, Sep 17, 2024 at 3:46=E2=80=AFPM Rob Sargent = wrote: > > > > On Sep 17, 2024, at 12:25=E2=80=AFPM, Adrian Klaver > wrote: > > > > =EF=BB=BFOn 9/17/24 09:21, Andy Hartman wrote: > >> The command work outside of powershell yes > > > > Then you are going to need to use whatever debugging tools PowerShell > has available to step through the script to figure out where the problem = is. > > > > > > Visual Studio can run/debug PS 1 files. I am not at my desk but have done > ps1 oneliner queries against mssql > > Suggest echoing ALL vars used in psql command > > > > > > --000000000000e4ea73062258ca89 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
I'll echo vars and see if something looks strange.
=
THanks.