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 1jmMeW-00033s-DC for pgsql-admin@arkaria.postgresql.org; Fri, 19 Jun 2020 19:26:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jmMeV-0007ag-9I for pgsql-admin@arkaria.postgresql.org; Fri, 19 Jun 2020 19:26:15 +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 1jmMeU-0007aK-K3 for pgsql-admin@lists.postgresql.org; Fri, 19 Jun 2020 19:26:15 +0000 Received: from sonic314-14.consmr.mail.bf2.yahoo.com ([74.6.132.124]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jmMeR-0006eD-0G for pgsql-admin@postgresql.org; Fri, 19 Jun 2020 19:26:13 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1592594768; bh=Shlq87hkptbSd8sy+cYuCctO/mIfImZF3NrOG93/RAs=; h=Date:From:Reply-To:To:Cc:In-Reply-To:References:Subject:From:Subject; b=jh2GiX7jPSe9+Je8vM89FM37BpxgqapPwayKoATI/TlVQJYOMDQC+dGmYX31GuhoLKCET+aB2zwILvoHjUGoaoWeHRdsWWSpge+W0sz+ntWi6kFvf4IUYi4whEcIsnemOfcwjwY4U3EYf/c2ZQxLwQCkJMbYh/1Y351vomN86yPJV/kLD8Q/26xSou1yJXUmfXKNboGolOxXAF/8H798kHJi2YAM31g/QIoOns7D1pfxLC8givUngqYow2g55pGW2CfJn6Xpi21R4EglCt6wPIPU+MlUs7dYwBOngpdh9yV/6KUJGRtPivuZfcA8PhsRde++7GeW4kb8/atwMJc59Q== X-YMail-OSG: 1JSZEcIVM1nRsRnp4iKOOv48eM8_sOFPKvKGCiylRkVbHyqH6WLy0gYttoADo19 iq4TGiXUzewZh3qwAs0irPMPtZfCT5y8WsjQiYr145ChBp6oUz8mMe.R8FESyEYrVyvfm_18aY.A .vZ0cGkVMwhG93k6Dw.CpLykIxS24bCy5FsMVyuywurJkobHnT.N9kkPsgSDkxwDlAbkO2VVMT1j OZqf9DNhebVdjAc.3lYkiEAFVbMT._l.0ZV9eKXdCa0Lsx1QJ8GcP00LwV9K4qKIJTP_6CNM5QQw Fg_JxvaLxKbN7vJ9CVlCsL5.IpxxZuuJcMO4sneekrr54YBHvs986.pUzg8x7R6Kewi5XofpdJ8v eLu0qgQzOcOBurNsD9zZvJQiGFfgoj69pto5ZNPekw4Z.uJxd5WMkuYpJU9vd.TDykexANVK48ZX 6TDpdFxvIEvfh26pFQuptRJcRiHQtqt8Lw7BSewgYWTL.vLhkAkeQ92fhNVXtzanfRqGi.U_mNcy iuN8hZ679Jwt8fNE4DgkuaFv02mLkQcN7IASsAafMrJIvvVnJr0jNOg1gsEh045svIza5yZBIVED op4gNADNiWMJJFnwZNb3tj3FI5t99V2wEcFibcJNDpJu54PN_impXaULMuCGyCvQMJcsisQP9tBD AHXPlGAWzuO8igV1R4gcwUWfaVZ_JarHx6M2V.s833VaTrfpl0yml3g01dz3FwL1jrdPxxWzKxuT enhKFGr1AmztFm8Bgynzadptdru0Xsx9EMJ_a23q8xONr.ABU11o3LwRUpk6b8X2edf8.kT.9Dgs aB7hcp_oU8JdZ4TeJIihmEaFRaJe5weQi1S6pAQHGl_vMFquKpoWomFfPFM3HU4P5TA2KYyrDBlK xgk9ZsuBNb10scjVVPchhaJv5J2djCkSmcGIFkNzMXRe1OIGzThd4vssq7wtg19OzyTh7wLwgkKy gaYDRG5K3Wiobv8UwUH3e8W3XYeI_lDYkz8fUWr34QvKF3INe.vqJum8e5yr7NyEvj880F7cyzWd rwNGXzlQZtld4kfEvTFaSIzjnwEGmYGWqmDwDAKvl4RkjwG.Bc41rE1.zCnfthmAS1_egAuJl_g0 FCvHfJcaCs9BC1UIYbhmksBe1evTTlbKj5s2qM0O_YGnQ_oLnXssLwPzS_8ZD2MRIA_wbvouR0X1 I14gvRiob.j7_cpU0HZr8R7ijpUyZ8ooicCHTXwTggPMpHvnzb9vBkUXf1DPPjBvrM9NYdBMWdNd XioO.d.CC_uoFnBuwTqv9edLNItE5MDSCyEzq5O2x5nP_Q3uqFcBKZLYAVPQ8ZdNoulWaUzJjTlG JGsc4xETpLcsVP51CjQ7X5btggUkvzy.SNqpcT6irzbyTM73P0PijN2U1eGSHXATlveT3iGhxGof JXjOUwngzepivgx4TemJ364kGygw_7SBV23MdIHhjDBM9Y5WICDky85CMpW4PiAuInHLfyD0IiWG CzWajG_1oW4JJ22u8BQ-- Received: from sonic.gate.mail.ne1.yahoo.com by sonic314.consmr.mail.bf2.yahoo.com with HTTP; Fri, 19 Jun 2020 19:26:08 +0000 Date: Fri, 19 Jun 2020 19:26:05 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: cgerard999@gmail.com, Adrian Klaver Cc: "David G. Johnston" , Christopher Browne , Pgsql-admin , Pgsql-general Message-ID: <1459334163.621977.1592594765361@mail.yahoo.com> In-Reply-To: References: <1278700189.536786.1592579255754@mail.yahoo.com> <8489125B-1921-4C14-AB31-16A05AEDF6D4@gmail.com> Subject: Re: create batch script to import into postgres tables MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_621976_1384913508.1592594765358" 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: 16029 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_621976_1384913508.1592594765358 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable thank you for all the information but I have no problem connecting to the d= atabase using pgAdmin and/or directly psql from the postgres database. I need to set up a batch/cron job to run in Linux/AWS to ingest the data.= =C2=A0 Therefore pgadmin GUI is not an option. I used pgAdmin to create tab= les, triggers, function triggers and manual importing/exporting.=C2=A0 You = can't schedule a time to run importing from=C2=A0 csv file(s) using pgAdmin= as same OEM.=C2=A0=C2=A0 The select table in this question is just an example for me to create scrip= ting to see=C2=A0it connect or not.=C2=A0 No one at work to manually run th= e script and enter the password.=C2=A0 Need to bypass it like Oracle script= ing.=C2=A0 Since this is not an option to put the password to connect to th= e database and run the script(s), we will find another way to do. I am thankful for all the input.=C2=A0=C2=A0 v/r, 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, 02:24:05 PM EDT, Adrian Klaver wrote: =20 =20 On 6/19/20 8:30 AM, cgerard999@gmail.com wrote: > There is an alternate solution, which is to launch pgadmin GUI, connect= =20 > to the database, tick =C2=AB save password =C2=BB > Then psql won=E2=80=99t prompt fir password any more. Pretty sure that is only within the context of pgAdmin. > Pay however attention to the security concern. >=20 > Sent from my mobile phone >=20 >> Le 19 juin 2020 =C3=A0 17:07, Pepe TD Vo a =C3=A9crit= =C2=A0: >> >> =EF=BB=BF >> appreciate for clarification, all inputs and teaching me more in=20 >> PostgreSQL >> >> have a good weekend and happy father's day to all who is Father. >> >> v/r, >> >> ** >> *Bach-Nga >> >> *No one in this world is pure and perfect.=C2=A0 If you avoid people for= =20 >> their mistakes you will be alone. So judge less, love, and forgive=20 >> more.EmojiEmojiEmoji >> To call him a dog hardly seems to do him justice though in as much as=20 >> he had four legs, a tail, and barked, I admit he was, to all outward=20 >> appearances. But to those who knew him well, he was a perfect=20 >> gentleman (Hermione Gingold) >> >> **Live simply **Love generously **Care deeply **Speak kindly. >> *** Genuinely rich *** Faithful talent *** Sharing success >> >> >> >> >> On Friday, June 19, 2020, 10:57:59 AM EDT, Adrian Klaver=20 >> wrote: >> >> >> On 6/19/20 7:52 AM, David G. Johnston wrote: >> > On Fri, Jun 19, 2020 at 6:58 AM Adrian Klaver=20 >> >> > > >> wrote: >> > >> >=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 ha= ving "--" on >> >=C2=A0 =C2=A0 password. >> >=C2=A0 =C2=A0 =C2=A0 > I did spelling out with --password=3Dmypassword >> > >> >=C2=A0 =C2=A0 Please go back and read my post again. >> > >> > >> > To be clear, there is no way to supply a password as a command line >> > argument.=C2=A0 It is fundamentally a bad=C2=A0idea and we don't even = make it an >> > option. >> >> Actually that is not entirely true, see my follow up post. >> >> > >> > You need to decide on one of the actual ways of supplying a=20 >> password, or >> > choose an alternative authentication method like peer. >> > >> > David J. >> >> > >> >> >> --=20 >> Adrian Klaver >> adrian.klaver@aklaver.com >> >> --=20 Adrian Klaver adrian.klaver@aklaver.com =20 ------=_Part_621976_1384913508.1592594765358 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
thank you for all the informat= ion but I have no problem connecting to the database using pgAdmin and/or d= irectly psql from the postgres database.

I need to= set up a batch/cron job to run in Linux/AWS to ingest the data.  Ther= efore pgadmin GUI is not an option. I used pgAdmin to create tables, = triggers, function triggers and manual importing/exporting.  You can't= schedule a time to run importing from  csv file(s) using pgAdmin as s= ame OEM.  

The select table in this question is just an example for me= to create scripting to see it connect or not. = ; No one at work to manually run the script and enter the password.  N= eed to bypass it like Oracle scripting.  Since this is not an op= tion to put the password to connect to the database and run the script(s), = we will find another way to do.

I am thankful for = all the input.  

v/r,

= <= /font>
Bach-Nga

No one in this world is pure and perfect.  If you av= oid people for their mistakes you will be alone. So judge less, love, and f= orgive more.3D"Emoji"3D"Emoji"
To call 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 gentl= eman (Hermione Gingold)

**Live simply **Love generously **Care deeply **Speak kindly.=
*** Genuinely rich *** Faithful talent ***= Sharing success




=20
=20
On Friday, June 19, 2020, 02:24:05 PM EDT, Adrian Klave= r <adrian.klaver@aklaver.com> wrote:


On 6/19/20 8:30 AM, cgerard999@gmail.com wrote:
> There is an alter= nate solution, which is to launch pgadmin GUI, connect
&= gt; to the database, tick =C2=AB save password =C2=BB
>= ; Then psql won=E2=80=99t prompt fir password any more.
<= br clear=3D"none">Pretty sure that is only within the context of pgAdmin.
> Pay however attention to the secur= ity concern.
>
> Sent from my mo= bile phone
>
>> Le 19 juin 20= 20 =C3=A0 17:07, Pepe TD Vo <pepevo@yahoo.com> a =C3= =A9crit :
>>
>> =EF=BB= =BF
>> 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.
>>
&= gt;> v/r,
>>
>> **
>> *Bach-Nga
>>
>> *No one in this world is pure and perfect.  If you avoid pe= ople for
>> their mistakes you will be alone. So j= udge less, love, and forgive
>> more.EmojiEmojiEmo= ji
>> To call him a dog hardly seems to do him just= ice though in as much as
>> he had four legs, a ta= il, 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 **Spea= k kindly.
>> *** Genuinely rich *** Faithful talent= *** Sharing success
>>
>><= br clear=3D"none">>>
>>
>= ;> On Friday, June 19, 2020, 10:57:59 AM EDT, Adrian Klaver
>> <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 Klaver
>> <adrian.klaver@akla= ver.com <mailto:adrian.klaver@aklaver.= com>
>> > <mailto:adrian.klaver@aklaver.com
>> <mai= lto:adrian.klaver@aklaver.com>>>= wrote:
>> >
>> >&nbs= p;   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 wit= h --password=3Dmypassword
>> >
>> >    Please go back and read my post again.
>> >
>> >
&= gt;> > To be clear, there is no way to supply a password as a command= line
>> > argument.  It is fundamentally a= bad idea and we don't even make it an
>> >= option.
>>
>> Actually tha= t is not entirely true, see my follow up post.
>>>> >
>> > You need to = decide on one of the actual ways of supplying a
>>= password, or
>> > choose an alternative authent= ication method like peer.
>> >
>> > David J.

>>
>> >
&g= t;>
>>
>> --
>> Adrian Klaver
>> adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>>
>>


--
Adrian Klaver
adrian.klaver@aklaver.com


------=_Part_621976_1384913508.1592594765358--