Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jmJ2U-000541-TI for pgsql-general@arkaria.postgresql.org; Fri, 19 Jun 2020 15:34:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jmJ2T-0004jX-RA for pgsql-general@arkaria.postgresql.org; Fri, 19 Jun 2020 15:34:45 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jmIyv-00049B-4P; Fri, 19 Jun 2020 15:31:05 +0000 Received: from mail-wm1-x342.google.com ([2a00:1450:4864:20::342]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jmIyq-0004cS-Gi; Fri, 19 Jun 2020 15:31:04 +0000 Received: by mail-wm1-x342.google.com with SMTP id l26so8802058wme.3; Fri, 19 Jun 2020 08:31:00 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=from:content-transfer-encoding:mime-version:subject:date:message-id :references:cc:in-reply-to:to; bh=EJ87t/4mIc13YEud7waPv9nOaciFr7d6vgDSQQsKnaM=; b=sPEnuVXBp4LxlPVHB3rogFLtmWv3plaACGD9jsqIQi6BnUd8kLt6tPT04RYTXwZHGF jO9U80rLGYgT8KJ5AvOGxaOwmIN1iizbKMsleLMjtLU9uZ9eIEs+uBevYgwhIdFsqXWB fBKF1ojOEKuELydsQdFmwh4s9B4uun6CJ/Ob1lbzuqQVx4EkUy+z9HOunexm04Rr0LSE DfYCKW5/jL/IgaL5YV6gdZQRFGfYWg+64t0A6q4yuUDNgZvNLovMtW/05+b6kBvMqiC4 tWZdfzSlCp/pDdJca88GZ9kZKIOuEB4cT8rrbvEBjLiWO8UGQ+57eX3GvY84kXAEDEuI AhYQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:content-transfer-encoding:mime-version :subject:date:message-id:references:cc:in-reply-to:to; bh=EJ87t/4mIc13YEud7waPv9nOaciFr7d6vgDSQQsKnaM=; b=mwdLDCObXyxJAhOQwc3mPNkdZZVLoFQ2XFsp7MNdEDUqP7XR0+15ypcvkRi3pz5TlD ydAvQpNAU1kozjrekAyXOli0jTw5Mt0sG5NR3j0JmTTIpBBTMGUd5rM10rOyp6HQPLHk ZG04kq9kzu3m/z0FbQO0yAXsHbCTlvHUNaRIwl2y5htcg24P3mACST1TBFAJytJ8h9ao jlhUhWfXGApGumVKVMb3GXXnEVKBxdky0WnftVJSprfjXt70tPesdDYrr3YHE9PXNZph uYfjXd7VT02xpFFe4iwYfakhvca0eIN4v9XTy5PzGxXkr8HU8EMfWydrpfKyORlk/Rbf FP1Q== X-Gm-Message-State: AOAM532ZwkUxe/sLkcgDsYi3gdasVb/IGNt9PK20XdguIAJ37iW6umHC i34FcXo4XfoMQyAM/pcuzYQvVbbrl80= X-Google-Smtp-Source: ABdhPJw6FmxagYwCbBK/atOMIYi6jlayHQjCP+elzr84LVozrtGZj4qmIPYry/9RbRdbxsfdWcVupg== X-Received: by 2002:a05:600c:2045:: with SMTP id p5mr4609990wmg.91.1592580658571; Fri, 19 Jun 2020 08:30:58 -0700 (PDT) Received: from ?IPv6:2a01:e0a:350:5680:8881:a15a:7972:aeb2? ([2a01:e0a:350:5680:8881:a15a:7972:aeb2]) by smtp.gmail.com with ESMTPSA id 23sm7422657wmo.18.2020.06.19.08.30.57 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 19 Jun 2020 08:30:57 -0700 (PDT) From: cgerard999@gmail.com X-Google-Original-From: Cgerard999@gmail.com Content-Type: multipart/alternative; boundary=Apple-Mail-0A51C679-60D8-47EC-B0E3-E5A37AA13A08 Content-Transfer-Encoding: 7bit Mime-Version: 1.0 (1.0) Subject: Re: create batch script to import into postgres tables Date: Fri, 19 Jun 2020 17:30:57 +0200 Message-Id: <8489125B-1921-4C14-AB31-16A05AEDF6D4@gmail.com> References: <1278700189.536786.1592579255754@mail.yahoo.com> Cc: "David G. Johnston" , Adrian Klaver , Christopher Browne , Pgsql-admin , Pgsql-general In-Reply-To: <1278700189.536786.1592579255754@mail.yahoo.com> To: Pepe TD Vo X-Mailer: iPhone Mail (17F80) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --Apple-Mail-0A51C679-60D8-47EC-B0E3-E5A37AA13A08 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable There is an alternate solution, which is to launch pgadmin GUI, connect to t= he database, tick =C2=AB save password =C2=BB =20 Then psql won=E2=80=99t prompt fir password any more.=20 Pay however attention to the security concern.=20 Sent from my mobile phone > Le 19 juin 2020 =C3=A0 17:07, Pepe TD Vo a =C3=A9crit := >=20 > =EF=BB=BF > appreciate for clarification, all inputs and teaching me more in PostgreSQ= L >=20 > have a good weekend and happy father's day to all who is Father. >=20 > v/r,=20 >=20 > Bach-Nga >=20 > No one in this world is pure and perfect. If you avoid people for their m= istakes you will be alone. So judge less, love, and forgive more. > To call him a dog hardly seems to do him justice though in as much as he h= ad four legs, a tail, and barked, I admit he was, to all outward appearances= . But to those who knew him well, he was a perfect gentleman (Hermione Gingo= ld) >=20 > **Live simply **Love generously **Care deeply **Speak kindly. > *** Genuinely rich *** Faithful talent *** Sharing success >=20 >=20 >=20 >=20 > On Friday, June 19, 2020, 10:57:59 AM EDT, Adrian Klaver wrote: >=20 >=20 > On 6/19/20 7:52 AM, David G. Johnston wrote: > > On Fri, Jun 19, 2020 at 6:58 AM Adrian Klaver > > wrote: > >=20 > > On 6/19/20 6:53 AM, Pepe TD Vo wrote: > > > Thank you sir and I am sorry for the typo not having "--" on > > password. > > > I did spelling out with --password=3Dmypassword > >=20 > > Please go back and read my post again. > >=20 > >=20 > > To be clear, there is no way to supply a password as a command line=20 > > argument. It is fundamentally a bad idea and we don't even make it an=20= > > option. >=20 > Actually that is not entirely true, see my follow up post. >=20 > >=20 > > You need to decide on one of the actual ways of supplying a password, or= =20 > > choose an alternative authentication method like peer. > >=20 > > David J. >=20 > >=20 >=20 >=20 > --=20 > Adrian Klaver > adrian.klaver@aklaver.com >=20 >=20 --Apple-Mail-0A51C679-60D8-47EC-B0E3-E5A37AA13A08 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable There is an alternate solution, which is to= launch pgadmin GUI, connect to the database, tick =C2=AB save password =C2=BB=  
Then psql won=E2=80=99t prompt fir password any more. 
Pay however attention to the security concern. 

Sent from my mobile phone

Le 19 juin 2020 =C3=A0 17:07, Pepe TD Vo <pepevo@yahoo.co= m> a =C3=A9crit :

=EF=BB=BF
appreciate for clarification, all i= nputs and teaching me more in PostgreSQL

have a good w= eekend and happy father's day to all who is Father.

v/r, 

Bach-Nga

No one in this world is= pure and perfect.  If you avoid people for their mistakes you will be a= lone. So judge less, love, and forgive more.3D"Emoj=3D"Emoji"3D"Emoji"
To call him a dog hardly seems to d= o him justice though in as much as he had four legs, a tail, and barked, I a= dmit he was, to all outward appearances. But to those who knew him well, he w= as a perfect gentleman (Hermione Gingold)

**Live simply **Love generously **Care deeply *= *Speak kindly.
*** Genuinely rich *** Faithful t= alent *** Sharing success
<= span class=3D"ydpf8dd9bc5yiv3811552299sg">

=


=20
= --Apple-Mail-0A51C679-60D8-47EC-B0E3-E5A37AA13A08--