Search Postgresql Archives

Re: create batch script to import into postgres tables

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux