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 1sqtyC-00DrbU-Po for pgsql-general@arkaria.postgresql.org; Wed, 18 Sep 2024 12:39:45 +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 1sqtyC-009H44-CH for pgsql-general@arkaria.postgresql.org; Wed, 18 Sep 2024 12:39:44 +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 1sqtyC-009H3w-16 for pgsql-general@lists.postgresql.org; Wed, 18 Sep 2024 12:39:44 +0000 Received: from mail-yb1-xb2c.google.com ([2607:f8b0:4864:20::b2c]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sqty4-001p6U-MH for pgsql-general@lists.postgresql.org; Wed, 18 Sep 2024 12:39:43 +0000 Received: by mail-yb1-xb2c.google.com with SMTP id 3f1490d57ef6-e1dc358d6aeso3184031276.3 for ; Wed, 18 Sep 2024 05:39:37 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1726663176; x=1727267976; 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=QOzVn+oC1sDHIrniMe2b+jXCyz1kD+ft8FwNtfzXlAc=; b=kY3OCnKumVuJGEMv4WGRRmSXTIATOYm3NwffTTqHh0//W5p0//DsMf84/CIgtpcd+e eSxehcqHM0Ry2wekNWUpfJqb2Ed/vk09Mw+FUov0q3wVPYxO8jQ6cM0gK/8G9F2NP6lv S05puGSN0g7f739+YlcjdGERCjsqRk1ArQfR5RlPD82UhrRdLVQ598OS4CTwuQT2Ox50 JbRarHJQbh7fTenlkG3Ocq7uMXRplwQ/cnweYAIqJ9vNvUjQm4vplC2cFPk5EAd5LZtJ fumcNiBVq8fLQ8UMl38Vv3qeUl+uXodxthcnTGP88isP301J9OtNpXrMFybCijtC65cD Ho3Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1726663176; x=1727267976; 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=QOzVn+oC1sDHIrniMe2b+jXCyz1kD+ft8FwNtfzXlAc=; b=euQ2KsRUnU14o7LYeAerMHiw3VGgEXdlIGDieono3b1AJjpm8tU3k26HclOYMNI6XP /uiSYhSzGyY2deo4dYJHR16iq1NK6MubWhaAdcoxmVBAjIWLm/hHR+jwCKYv5fqIHqEl mx5fxBFBGNhhhMJhppAhX0TUxmVHSCfQsMVzaTEeD39NpS/zdV3N5fw5jgjhyzb67xfo 1mKPAoNCXX+S/iobEgkdRI8LcCHow/T2VHDM8GTRfhdTjVaFeB4yJ3zGbXV5YJHrgNDV EjCmXpJt5lS7guLbNKDCh6s5Zd5DpkWotzF2DNGNGKvGqVsy8++nCkE5t0egi8FHd8Uw xBDg== X-Forwarded-Encrypted: i=1; AJvYcCW+e31maL5pjl9t0LLsm9R56Ig4Rbgs5+y8VukksTMtpBq1LOwNTXgHcofwaSpMWQHFJ6LDODE1Ce5B6ulH@lists.postgresql.org X-Gm-Message-State: AOJu0YxRMrtRLZWuS4Ch9AMuP2T1DkL+gNN1CcSpVduu0YJiZ5J5wM8z 2SinyTxZS8RIXwKGQNqueSBJNmwY7Ih0Ak+bfccJC/OHZr7QJW9q0B9509POtdRTROGG/VrpAUZ vW2upbFhBIEdWIet0/0KCIW0sYtA= X-Google-Smtp-Source: AGHT+IE7LCQMYLv8LCmZIDcEV14m1E29rCDnYOpMbipWQxPHt+ZmGxe+PhmUmzmeebVBnSGbx8so6mlhwf1PO412m64= X-Received: by 2002:a05:6902:2d03:b0:e1d:79b2:ba2b with SMTP id 3f1490d57ef6-e1d9dbc1f41mr18496785276.21.1726663175797; Wed, 18 Sep 2024 05:39:35 -0700 (PDT) MIME-Version: 1.0 References: <0e48b60d-7beb-4f40-9de7-371710dd4d1b@aklaver.com> In-Reply-To: From: Andy Hartman Date: Wed, 18 Sep 2024 08:39:24 -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="0000000000003d86030622641970" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000003d86030622641970 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable psql -h $pgServer -d $pgDatabase -U $pgUser -c $copyCommand I'm wondering if it's waiting on P/w ? Thanks. On Tue, Sep 17, 2024 at 7:10=E2=80=AFPM Andy Hartman wrote: > 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 don= e >> ps1 oneliner queries against mssql >> >> Suggest echoing ALL vars used in psql command >> >> > >> > >> > --0000000000003d86030622641970 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
psql -h $pgServer -d $pgDatabase -U $pgUs= er -c $copyCommand=C2=A0

I'm wonde= ring if it's waiting on P/w ?

Thanks.

On Tue, Sep 17, 2024= at 7:10=E2=80=AFPM Andy Hartman <hartman60home@gmail.com> wrote:
I'll echo vars and see if = something looks strange.

THanks.

On Tue, Sep 17, 2024 at 3:46=E2=80= =AFPM Rob Sargent <robjsargent@gmail.com> wrote:


> On Sep 17, 2024, at 12:25=E2=80=AFPM, Adrian Klaver <adrian.klaver@aklaver.com<= /a>> wrote:
>
> =EF=BB=BFOn 9/17/24 09:21, Andy Hartman wrote:
>> The command work outside of powershell=C2=A0 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 p= s1 oneliner queries against mssql

Suggest echoing ALL vars used in psql command

>
>
--0000000000003d86030622641970--