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 1jmIcL-0004L7-Ix for pgsql-admin@arkaria.postgresql.org; Fri, 19 Jun 2020 15:07:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jmIcK-0007br-Fk for pgsql-admin@arkaria.postgresql.org; Fri, 19 Jun 2020 15:07:44 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jmIcJ-0007bj-VM for pgsql-admin@lists.postgresql.org; Fri, 19 Jun 2020 15:07:44 +0000 Received: from sonic301-2.consmr.mail.bf2.yahoo.com ([74.6.129.41]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jmIcG-0005OA-Rn for pgsql-admin@postgresql.org; Fri, 19 Jun 2020 15:07:43 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1592579258; bh=OzumMiP/5OifpF5B6LeyhLodfhYB072B8trKCcpE2+8=; h=Date:From:Reply-To:To:Cc:In-Reply-To:References:Subject:From:Subject; b=oHoPEGzzbzz8oxvEoZdvRVJ9Vp6b4v85iTgPOfCiS52VQcKTtJ2QbKVw01gOTluYKxLvag9LdjlgDBp8Vs28xtvrVWEHDrOg5n/Fu7lgvJHYIUm9G4w5KyMMFh4aPoYi7Tc9OYV2sUmVrXPNAGJgY44dl4oogAeF5o88xLEfPz82dvJFa+sDGM/Tk31BJvveM6g6PkmkhOpCoAimIXKOU7DpE0ZOCbd3kq07jP0k595gonoaa61aLr+etSsa61I++RUHUenNygGRCB8Ob1XX5HKfXZ1TGHIArvvKuQTN5tyQUUbvBNskPaLnV/TIpGsknWG6dS6eEPbSLArr3MdDkA== X-YMail-OSG: 4eMUtvIVM1kh0Yl1MFxdn1hr7Ian26fDuScTcUkHoxSzXpL1goPMhUchCzPjvRn AupkQ3_Z1lHCExlggogWTZM6gYhIWr427YcAfh5T8jc17WMjDQJE8Rqsf2yj3FN5G_QICEVIipaD FgBvzNM7G7J4DgfhR.3IvuX2YFR0wfvJOdrZGPbLWeiwyHhElIyoPMBcUbI6OxohKoqQO90jS7Ci iJnIWW9zSk9MrbIqMVfcODl_Nqvxy9In2cBfkFw98j28caDrLhjZWaf2N.H_0dK_kIRFYbQL0BZN ycz59PyDEheHjpJ4TngrtdUy1OexqwMMLMzerff0Nq_zGU4Npaq5RwQGEsHTOlHc01fhrCvdUsHY ITfIYDxIZypr.AU8prfAzBZjo2smrIs3C_Ulubez8ViLjhxvZZLgzSE8WqxW440nnMGAVkeZm7il XGtyQH5.h0b4ePZpHmK03dBP8sVi0TNkiNkv_mrlcuE0o.Woa8HdHcF5s3ruVtMYMdUUPm0oAtHb iyfzWRmIvO2dlwyFM.ga4wT6TN4lkPt2WA5b.usy_Q_V5ag.9dRuuYhvG64vW0D_7tTQXy.7xLr9 m7DQJ94zJgxHvRVYiQGZx6QWZfRTfXks9P78ffMY1LGU447hdxQmITwd7j7XfR9gPQan__mrCdcj JdZEhL_T4cwB26TnzG4mjHiTX4tZuYsnN0Tc_I0Oe3Pkb.J09P5oP_PMlQW9iWHL302yiX1eDLej 0.6cOPcUyLY1oXUBu0UB8JXM68hP7Hdu5P4UrNbmDD1yvo2ZH1Hfnn667slb_sQi29qeT4F2KQRg MU3ohvvhqdvCssd1jhwvGl6ZuBRgTdz_SAgLX..w7phmgkoHznHRPHyTWvYXpLuxEhBxVqurwCyI yISacJF0awxCYp3.BI1poolHh5xaf4x69arLZwbAOEdtvgQ.08hjoy_PZE_J9doI.CmIMxRD.uX0 DTvynB7IhXpkYzZazMJ9MTx2uU_m97qXJUw3lWi16e_BQ5lEH0I9XuWHJbOYnFdQbQoeHPs2DZnd fjG2yYwjrGEhKrC1Io_IU_yfZ3GdpCSGdkB7xxhlVeyxXFCy8WVPjV3VMiWLLex2f5hF0UamLA4E yzZiELCSKTHW4V54M2cB2H2SpRrZt4L6_z8G_aR0IAQ58O3ltygiTnFuId0K0b.NvVjNtjndJ3Me T6tdO0V0iOpPOXj5yIoU2b7jlpdmRvSA_BTdyd2L_kmhlr_QZIU6Pftu9ecDc4THfaA7c3EOEkUi 8Pcv.qwx6fppztZEoeiomJjjJaul36XOx.sBh2eKIoPEQD7rj7Zs9MVtVJFMt4nvmpUTUWrnhdlb _73.mR.NDhpk_qoHCqxlST8pu707yomdsC5OuqHKJUxShkakRK8J4N23wK4GRPyaraMXAyzmpyh6 nDGdR2uZR6y88I_1uG6Y8pHg95CnaOX2XZgY8ObsOgDI0eUJI7Ehy9O8VTzNTU1Ihv7uADOFTn1e JJABPuew3Akvmise7lBlD Received: from sonic.gate.mail.ne1.yahoo.com by sonic301.consmr.mail.bf2.yahoo.com with HTTP; Fri, 19 Jun 2020 15:07:38 +0000 Date: Fri, 19 Jun 2020 15:07:35 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: "David G. Johnston" , Adrian Klaver Cc: cgerard999@gmail.com, Christopher Browne , Pgsql-admin , Pgsql-general Message-ID: <1278700189.536786.1592579255754@mail.yahoo.com> In-Reply-To: <092a1674-0415-f5b4-0d04-b2a18d03778b@aklaver.com> References: <37a9ad71-b297-96b3-9c1f-1043e75dec58@aklaver.com> <939136830.464657.1592565150445@mail.yahoo.com> <519aa822-cb75-0565-1073-180c911f40a7@aklaver.com> <448905667.492834.1592574816699@mail.yahoo.com> <3bbdbc7b-0ca8-b162-5967-5822cc2edfd3@aklaver.com> <092a1674-0415-f5b4-0d04-b2a18d03778b@aklaver.com> Subject: Re: create batch script to import into postgres tables MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_536785_182870285.1592579255752" X-Mailer: WebService/1.1.16138 YMailNorrin Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.106 Safari/537.36 Content-Length: 8725 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_536785_182870285.1592579255752 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable appreciate for clarification, all inputs and teaching me more in PostgreSQL have a good weekend and happy father's day to all who is Father. v/r,=C2=A0 Bach-Nga No one in this world is pure and perfect.=C2=A0 If you avoid people for the= ir mistakes you will be alone. So judge less, love, and forgive more.To cal= l him a dog hardly seems to do him justice though in as much as he had 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 Gingold) **Live simply **Love generously **Care deeply **Speak kindly.*** Genuinely = rich *** Faithful talent *** Sharing success =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 >=C2=A0 =C2=A0 On 6/19/20 6:53 AM, Pepe TD Vo wrote: >=C2=A0 =C2=A0 =C2=A0 > Thank you sir and I am sorry for the typo not havin= g "--" on >=C2=A0 =C2=A0 password. >=C2=A0 =C2=A0 =C2=A0 > I did spelling out with --password=3Dmypassword >=20 >=C2=A0 =C2=A0 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.=C2=A0 It is fundamentally a bad=C2=A0idea and we don't even mak= e it an=20 > option. Actually that is not entirely true, see my follow up post. >=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 Adrian Klaver adrian.klaver@aklaver.com =20 ------=_Part_536785_182870285.1592579255752 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
appreciate for clarification, all= inputs and teaching me more in PostgreSQL

have a good weekend and happy father's day to all who is Father.

v/r, 

<= font id=3D"ydpf8dd9bc5yui_3_13_0_rc_1_1_1381789421038_7870" color=3D"#8000f= f" style=3D"background-color: inherit;">Bach-Nga

No = one in this world is pure and perfect.  If you avoid people for their = mistakes you will be alone. So judge less, love, and forgive more.3D"Emoji"3D"Emoji"= 3D"Emoji"
**L= ive simply **Love generously **Care deeply **Speak kindly.
*** Genuinely rich *** Faithful talent *** Sharing success<= /font>


<= /div>


=20
=20
On Friday, June 19, 2020, 10:57:59 AM EDT, Adrian Klave= r <adrian.klaver@aklaver.com> wrote:


On 6/19/20 7:52 AM, David G. Johnston= wrote:
> On Fri, Jun 19, 2020 at 6:58 AM Adrian Klave= r <adrian.klaver@aklaver.com
> <mailto:adrian.klaver@akl= aver.com>> wrote:
>
>&= nbsp;   On 6/19/20 6:53 AM, Pepe TD Vo wrote:
>&= nbsp;     > Thank you sir and I am sorry for the typo not havi= ng "--" on
>    password.
>      > I did spelling out with --password=3Dmypassw= ord
>
>    Please go = back and read my post again.
>
>=
> To be clear, there is no way to supply a password = as a command line
> argument.  It is fundamental= ly a bad idea and we don't even make it an
> opt= ion.

Actually that is not entirely tru= e, see my follow up post.

>
> You need to decide on one of the actual ways of supplying = a password, or
> choose an alternative authentication= method like peer.
>
> David J.<= div class=3D"yqt9911850626" id=3D"yqtfd48965">
>


--
A= drian Klaver
adrian.klaver@= aklaver.com


------=_Part_536785_182870285.1592579255752--