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.g.johnston@xxxxxxxxx>
Date: 6/19/20 20:24 (GMT-05:00)
To: pepevo <pepevo@xxxxxxxxx>
Cc: Adrian Klaver <adrian.klaver@xxxxxxxxxxx>, cgerard999@xxxxxxxxx,
Christopher Browne <cbbrowne@xxxxxxxxx>, Pgsql-admin
<pgsql-admin@xxxxxxxxxxxxxx>, Pgsql-general <pgsql-general@xxxxxxxxxxxxxx>
Subject: Re: create batch script to import into postgres tables
On Friday, June 19, 2020, pepevo <pepevo@xxxxxxxxx
<mailto:pepevo@xxxxxxxxx>> 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.klaver@xxxxxxxxxxx
