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 1jmMpy-0003Nq-Gv for pgsql-admin@arkaria.postgresql.org; Fri, 19 Jun 2020 19:38:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jmMpx-00086m-Dv for pgsql-admin@arkaria.postgresql.org; Fri, 19 Jun 2020 19:38:05 +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 1jmMpv-00086R-Uw; Fri, 19 Jun 2020 19:38:05 +0000 Received: from out4-smtp.messagingengine.com ([66.111.4.28]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jmMpr-0007pc-Au; Fri, 19 Jun 2020 19:38:03 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id 15B265C003D; Fri, 19 Jun 2020 15:37:57 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute4.internal (MEProxy); Fri, 19 Jun 2020 15:37:57 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= subject:to:cc:references:from:message-id:date:mime-version :in-reply-to:content-type:content-transfer-encoding; s=fm3; bh=X xGdiuD/E8EiyA3r4HBpnbqd3j1WU/4zWZos+nX3xPY=; b=cffrzbp5u3KyFJVe4 MYMZS77w6gpBMlDTLDiUcfMzTPHnYLR1Lgspys9MoLz1HJcuFt6QdB+uhC5r4sE2 g2PGgaWVRFXDXXr8AkLiJztsCPxC9riVrp+2GKcF2YWRChQphf7j5hyaAL+LtkN1 ZdiwdvxtjRZpaWwoDw0d9U4msetYu1vtPx2yOJFQ5h6rScGyLa9nXwjwbLGbIr67 iaViyIEqHNgDzUAUf4n8PyGCiy+LMw92tPDIGa2O3h4rM9IznYNMmEwFX/M38xSo DB9rHBiLYP8FdgHSGMBDwRFUR4lKmJ5SExv+gGno3jCInYBlVqRgV1D5dPpk+Go/ 60QpQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:references :subject:to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender :x-sasl-enc; s=fm3; bh=XxGdiuD/E8EiyA3r4HBpnbqd3j1WU/4zWZos+nX3x PY=; b=DImYCv9Z60r1PWJb6wqPlchK7zxvxqApySA87TmnNe6/q+5irN/djU+GW 5jxnWbhOSJtjPemEUvxSuQtLcGr3LNTl3V+ZXOL9qRbtQ/o01ESP5iHfRY5Vkmeu USNNk9+jgFtcaQjWD4quexeNIeAhFq7DBNEf7spBlGtK54jwk0J5k6YUlL6qjM89 UVZAwejqhICUk2eiImST0Ym86+DdES14qdvYpJeBlijO70gg/UdZ9F/tO2jDKlwH haeDuR/nDivOz0SZjZvV+w1vXv3z1v8w2A4GOch5oPZ4oY4iLcoWn/Jx5Hv9kFly bXrp1NvuhC43xNrKbEZTbGJT6lW2w== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduhedrudejiedgudegtdcutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfgh necuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmd enucfjughrpefuvfhfhffkffgfgggjtgfgsehtkeertddtfeejnecuhfhrohhmpeetughr ihgrnhcumfhlrghvvghruceorggurhhirghnrdhklhgrvhgvrhesrghklhgrvhgvrhdrtg homheqnecuggftrfgrthhtvghrnhepieevtdekudejvefffeehieetfeduffeuudehjefg geekgfdtfffhleeljeffvefgnecuffhomhgrihhnpehpghgrughmihhnrdhorhhgnecukf hppeejhedrudejvddrhedrvdefudenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgr mhepmhgrihhlfhhrohhmpegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtoh hm X-ME-Proxy: Received: from [192.168.1.3] (75-172-5-231.tukw.qwest.net [75.172.5.231]) by mail.messagingengine.com (Postfix) with ESMTPA id 1079E3062499; Fri, 19 Jun 2020 15:37:55 -0400 (EDT) Subject: Re: create batch script to import into postgres tables To: Pepe TD Vo , cgerard999@gmail.com Cc: "David G. Johnston" , Christopher Browne , Pgsql-admin , Pgsql-general References: <1278700189.536786.1592579255754@mail.yahoo.com> <8489125B-1921-4C14-AB31-16A05AEDF6D4@gmail.com> <1459334163.621977.1592594765361@mail.yahoo.com> From: Adrian Klaver Message-ID: <58732fe2-5f50-ffd9-71ae-f757b7a61cd4@aklaver.com> Date: Fri, 19 Jun 2020 12:37:55 -0700 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Thunderbird/68.9.0 MIME-Version: 1.0 In-Reply-To: <1459334163.621977.1592594765361@mail.yahoo.com> Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: en-US Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 6/19/20 12:26 PM, Pepe TD Vo wrote: > thank you for all the information but I have no problem connecting to > the database 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.  Therefore 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 same OEM. There is pgAgent: https://www.pgadmin.org/docs/pgadmin4/development/pgagent.html > > 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.  Need to bypass it like Oracle > scripting.  Since this is not an option to put the password to connect > to the database and run the script(s), we will find another way to do. But there is an option. > > I am thankful for all the input. > > v/r, > > > ** > *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.EmojiEmojiEmoji > 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 gentleman > (Hermione Gingold) > > **Live simply **Love generously **Care deeply **Speak kindly. > *** Genuinely rich *** Faithful talent *** Sharing success > > > > > On Friday, June 19, 2020, 02:24:05 PM EDT, Adrian Klaver > wrote: > > > On 6/19/20 8:30 AM, cgerard999@gmail.com > wrote: > > There is an alternate solution, which is to launch pgadmin GUI, connect > > to the database, tick « save password » > > Then psql won’t prompt fir password any more. > > Pretty sure that is only within the context of pgAdmin. > > > Pay however attention to the security concern. > > > > Sent from my mobile phone > > > >> Le 19 juin 2020 à 17:07, Pepe TD Vo > a écrit : > >> > >>  > >> 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, > >> > >> ** > >> *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.EmojiEmojiEmoji > >> 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 > >> 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 > >> > wrote: > >> > >> > >> On 6/19/20 7:52 AM, David G. Johnston wrote: > >> > On Fri, Jun 19, 2020 at 6:58 AM Adrian Klaver > >> > > > >> > > >> >>> wrote: > >> > > >> >    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=mypassword > >> > > >> >    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 fundamentally a bad idea 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 > >> password, or > >> > choose an alternative authentication method like peer. > >> > > >> > David J. > > >> > >> > > >> > >> > >> -- > >> Adrian Klaver > >> adrian.klaver@aklaver.com > > > >> > >> > > > -- > Adrian Klaver > adrian.klaver@aklaver.com > > -- Adrian Klaver adrian.klaver@aklaver.com