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 1jlCSX-0007e6-T9 for pgsql-general@arkaria.postgresql.org; Tue, 16 Jun 2020 14:21:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jlCSW-0006xT-Q5 for pgsql-general@arkaria.postgresql.org; Tue, 16 Jun 2020 14:21:04 +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 1jlCSW-0006xM-6F for pgsql-general@lists.postgresql.org; Tue, 16 Jun 2020 14:21:04 +0000 Received: from sonic314-13.consmr.mail.bf2.yahoo.com ([74.6.132.123]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jlCST-0006dZ-9N for pgsql-general@postgresql.org; Tue, 16 Jun 2020 14:21:03 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1592317259; bh=BlWmkBKz5ds+Ym3RqLZq3aeqwLlmRQxFs7ZxOSCgzOA=; h=Date:From:Reply-To:To:Subject:References:From:Subject; b=SkTo19vsSFMFmJXAqH8qO8yX8aDQ4EA9qw+V+OLYbarLkM25mnyNxdBZnAeSOypSsWtMsxAY/bab4j2imEVoYtVNJ+au4wIK0K55SgdbI7NTeqbQoUG4KsEOQb/xlrMAwJFtxYtbLak3nIMenolynn+eGuqJStZeUtm1q8w5OGJ7x7eY/sRN+qDRPjIGHWTm5NgLjvj3wsa24Pw/rYoiJd9DZlM9Rxs6XckzHvnJc2ctUkTlFktPYz8EUU47dCz0jgfKdqKTS0dvL4EO+PlsgJnqiTqSOM9a1bzTUQn+hjkzDpyQX0Z+o9POQj+M34mz5Vittn5CfXOi5eJfZnujQw== X-YMail-OSG: Wi08Gj4VM1kJJa96uWCMEwSufR8z3grq_prYk_kvWjH_sJmx24AYKySxyod3SfA y2MncjvPgschFlHvPK90Ex7MUD8rCmLA2zdNGqNtjj.88YrlckDHyVfCKbiez9ng9rts0wLdxnWM RbVjYfoAhu3jXE13dVPB4r7.OnqLsiheYtzOjI2G_laCdBXWtsp4MkJ5LWfvbtlmpCIA72CEy.IK pcL2PpcP63I_tv2dwHQTmyQ6L0hiP5aBWGT7uyuRub81bIZ6XgArzqqa6Rrwcwd2d3f0vd7Khiii Gi9l0KFQRmE.BC5UgCKdKwCZbsziF2oUc0iHsqyCOLioD08exAl_mRJ5jlhiL0R2FOSTq8fsjXBB EU.pj5YRofU4WWlkIppkDbkPFX7b5QgjuIGydikzsKOD8cTAr2qUx86aUT5JWpUuGn90a87vmgdY tm8eHvm110CoO65MjsxUf91FOuIKtiu0dfxo9FkYxJggq1MPGXymkg.FKbQkdMlOUlRGu5969MUD AtIK_hNFkgxTMjcMi5QFgfP7FxBJnOS_R6XjcyLPaBRlluWWIfVLon2hEOu70A6h68v2NtN10X7f 2O5VGoo7JSl53soyK1d7HTZd9eN5ncz1yk6BfR6Q25NCn3FCXV01AbAMrLixVToArMJmplktRToI 1WYRgr1FSZe6h6v5KfrEQVOKy6y_1mVi7WQh5CNlAwYueG5aemY8Ph_0fSBhtakxB0l4sW6Bdjjc vq0w22L3ZahL20eeFCc6PdIMOPgiv_pqB4ZTIigKKqAg2c8ugJBudog.igkBa9j6ndcakGFqAB4_ H7BRt8WiLpZoYPySph.FnbW.QNliGsD64KXzs26tNjmbqNHSaWKrfrfQqLu_gpUkouFJHoYiv7bn qRpj9IHuyBpqukNJZygCwqJds Received: from sonic.gate.mail.ne1.yahoo.com by sonic314.consmr.mail.bf2.yahoo.com with HTTP; Tue, 16 Jun 2020 14:20:59 +0000 Date: Tue, 16 Jun 2020 14:20:56 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: Pgsql-general , Pgsql-admin Message-ID: <866581879.1147164.1592317256828@mail.yahoo.com> Subject: create batch script to import into postgres tables MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1147163_2021221965.1592317256826" References: <866581879.1147164.1592317256828.ref@mail.yahoo.com> X-Mailer: WebService/1.1.16119 YMailNorrin Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.97 Safari/537.36 Content-Length: 6580 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_1147163_2021221965.1592317256826 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable good morning experts, I n=C3=AAd to set up a batch script to import multi csv files to import the= m to Postgres tables.=C2=A0 Each csv files will be named table1_todaydate.c= sv, table2_todaydate.csv, etc... tablen_todaydate.csv.=C2=A0 Each csv file = will import to its table and how do I execute the script to called psql fro= m AWS?=C2=A0 Do I need to create each batch file for import each table? all export file is store in c:\export\files\ thank you. Bach-Nga 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 ------=_Part_1147163_2021221965.1592317256826 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
good morning experts,

I n=C3=AAd to set up a batch script= to import multi csv files to import them to Postgres tables.  Each cs= v files will be named table1_todaydate.csv, table2_todaydate.cs= v, etc... tablen_todaydate.csv.  Each csv file will import to its tabl= e and how do I execute the script to called psql from AWS?  Do I need to create each batch file for import each table?=

all export file is store in c:\exp= ort\files\

thank you.

<= /div>
Bach-Nga

<= span>
<= span>
<= span>

= Bach-Nga

No one in this world is pure and perfect.&= nbsp; If you avoid people for their mistakes you will be alone. So judge le= ss, love, and forgive more.3D"Emoji"3D"Emoji"3D"Emoji"=
To call him a dog hardly seems to do hi= m justice though in as much as he had four legs, a tail, and barked, I admi= t he was, to all outward appearances. But to those who knew him well, he wa= s a perfect gentleman (Hermione Gingold)

**Live simply **Love generously **Care deepl= y **Speak kindly.
*** Genuinely rich *** Fa= ithful talent *** Sharing success

------=_Part_1147163_2021221965.1592317256826--