Re: create batch script to import into postgres tables

On 6/19/20 6:28 PM, pepevo wrote:
> Yes, and I am thank you for all your helps.  As I said and if you
> contract for Govt you should know,  we can't just install the software
> without their approval.   When someone suggested psql client to run
> batch script when I can't putty into the AWS instance.  I need to asked
> lead to approval to download even I don't have administrative
> privileges and because it's on Dev and  it's on our server.  Real work
> will be on Linux production and everything need to be approved by
> Government.  But everything can run by script on the server, right?

Alright now I am thoroughly confused. You where asking how to connect
from a Windows using psql to run a batch script from Windows machine. No
mention of any government restrictions, or approval to download. Also,
now you say you will be working on Linux machine and the script will run
on server. So basically your original question has nothing to do with
reality. Correct me if I am wrong.

> Also, I will take a look on pgpass per Adrian's suggestion when I am
> back onsite.   I am still learning Postgres here and have limited on the
> server.
>
> I appreciated for all the helps here.
>
> Bach-Nga
>
> Sent from my Metro By T-Mobile 4G LTE Android Device
>
>
> -------- Original message --------
> From: "David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
> Date: 6/19/20 20:24 (GMT-05:00)
> To: pepevo <pepevo(at)yahoo(dot)com>
> Cc: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, cgerard999(at)gmail(dot)com,
> Christopher Browne <cbbrowne(at)gmail(dot)com>, Pgsql-admin
> <pgsql-admin(at)postgresql(dot)org>, Pgsql-general <pgsql-general(at)postgresql(dot)org>
> Subject: Re: create batch script to import into postgres tables
>
> On Friday, June 19, 2020, pepevo <pepevo(at)yahoo(dot)com
> <mailto:pepevo(at)yahoo(dot)com>> wrote:
>
> We can't just install any softwares without Goverment's approval.
> Also, they might ask Oracle/mysql/sql can run batch script, why not
> Postgres?  I wonder myself and just realize today from this email.
>
>
> PostreSQL isn’t the issue here, you are.  To the extent that others
> attempting to help you over email are insufficient is a failing driven
> mainly by the medium of choice probably being an inefficient medium for
> the student.  What you want to do is possible but it requires
> understanding multiple applications.  You are better off getting closer
> to your goal by reading books and articles about those applications and
> then asking better questions.  Or at minimum being more detailed in
> stating your goal and requirements.
>
> David J.
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com