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 1sqe9M-00BUtX-Cr for pgsql-general@arkaria.postgresql.org; Tue, 17 Sep 2024 19:46:13 +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 1sqe9L-00FQwL-Ga for pgsql-general@arkaria.postgresql.org; Tue, 17 Sep 2024 19:46:11 +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 1sqe9L-00FQw9-5G for pgsql-general@lists.postgresql.org; Tue, 17 Sep 2024 19:46:11 +0000 Received: from mail-qk1-x72a.google.com ([2607:f8b0:4864:20::72a]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sqe9F-001hMb-Ql for pgsql-general@lists.postgresql.org; Tue, 17 Sep 2024 19:46:10 +0000 Received: by mail-qk1-x72a.google.com with SMTP id af79cd13be357-7a9aa913442so467542885a.1 for ; Tue, 17 Sep 2024 12:46:06 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1726602365; x=1727207165; darn=lists.postgresql.org; h=to:in-reply-to:cc:references:message-id:date:subject:mime-version :from:content-transfer-encoding:from:to:cc:subject:date:message-id :reply-to; bh=6ntR7OU+kOXfVzMKDhx8GVviZBYy+VOrhusoW3rtpC8=; b=glWP6YT1l3mHpS3L86ZHcYUNs4tN20lCVuMV9mDpYwFit65hcms4Zed85sDfp2RsZ3 /WayplSvpmXSwCQKzY6tKoY8NWYbWgXh5jkzbewcyANZF+cBBVZCZDk6MAS08LwZj+G2 h2uWEJUHXk7OupC2qHo6L0tA0XQfJ3vwAJBalxPDAZ8Gy1gglQFZLNJIv/dv4sDsOHwS glWE0Tx0MQBemD/+Yc8DteNbRchd8BCmJCC8w25t2wfimFJOrCTBjpZyO60G8SsFQR/u 8+dcmeFqUzLnj2vCUNR2Ym4fEdir3Z3cijYwtPU1YWCxNxNKSxqzLml1vZxEdZ958HPk VNZw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1726602365; x=1727207165; h=to:in-reply-to:cc:references:message-id:date:subject:mime-version :from:content-transfer-encoding:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=6ntR7OU+kOXfVzMKDhx8GVviZBYy+VOrhusoW3rtpC8=; b=tF1XXPLakjC8Tgj18qZArzh/zx9tNZeI0KKFdnT1kJbUR7IvLITrHNUmg7jcQ9IYdr uJrOEXAidujICZr60wWpwX4+fHOiRAhLP0W8SsLX/ajR8i7VIiFQwNIs8cU7uGUF9vKO Glnj4L39UjDltEZ/4IrZ570RFCzBfIMrPCDDDhtzjFPvq5gz7hxUhtiekjSiJNztFN1i 7/V4VeDm23o9k3phOv3F8Rg1gScHiCzzxuT7JfwzW0APghq3psctYm7XLEgjvyA4P0AR nasBmE0tCHo2APkeUL9tf1jqsYtRD1eeBHOnoFdwAcJdBpatRdNkam0iBRIdpTevGP2I FgFg== X-Forwarded-Encrypted: i=1; AJvYcCW8/TJspVvugXWRKFWG9zQa7edg957608prb11WYLqnhA1kPMX8E970VGMdCxEA+wgYfrzZrvjGXpa7mrad@lists.postgresql.org X-Gm-Message-State: AOJu0YwHK8JGicIj8Q+CbKiDgqT4lN9TOedIC6/zE9sbUe4edvu6Pt0x pzse5jYWJYNChSpkXP2hBYTBxdp7t5gkiEXoojRJtXFKnhTfpEEL X-Google-Smtp-Source: AGHT+IG2aJe6pkGol8uLavPWjGzJMW+0aPJGXPcpmpq8MTZI4MLxLjgLWpgNgS5RB3zsUDC53IM8yQ== X-Received: by 2002:a05:620a:28ca:b0:7a9:d0ec:2d8f with SMTP id af79cd13be357-7ab30d4391bmr2382531985a.24.1726602365064; Tue, 17 Sep 2024 12:46:05 -0700 (PDT) Received: from smtpclient.apple ([69.38.227.226]) by smtp.gmail.com with ESMTPSA id af79cd13be357-7ab3e96476bsm394292385a.15.2024.09.17.12.46.04 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 17 Sep 2024 12:46:04 -0700 (PDT) Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable From: Rob Sargent Mime-Version: 1.0 (1.0) Subject: Re: load fom csv Date: Tue, 17 Sep 2024 15:45:53 -0400 Message-Id: References: <0e48b60d-7beb-4f40-9de7-371710dd4d1b@aklaver.com> Cc: Andy Hartman , Muhammad Usman Khan , pgsql-general@lists.postgresql.org In-Reply-To: <0e48b60d-7beb-4f40-9de7-371710dd4d1b@aklaver.com> To: Adrian Klaver X-Mailer: iPhone Mail (21G93) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On Sep 17, 2024, at 12:25=E2=80=AFPM, Adrian Klaver wrote: >=20 > =EF=BB=BFOn 9/17/24 09:21, Andy Hartman wrote: >> The command work outside of powershell yes >=20 > Then you are going to need to use whatever debugging tools PowerShell has a= vailable to step through the script to figure out where the problem is. >=20 >=20 Visual Studio can run/debug PS 1 files. I am not at my desk but have done ps= 1 oneliner queries against mssql Suggest echoing ALL vars used in psql command >=20 >=20