Re: create batch script to import into postgres tables - Mailing list pgsql-admin

From Adrian Klaver
Subject Re: create batch script to import into postgres tables
Date
Msg-id 37a9ad71-b297-96b3-9c1f-1043e75dec58@aklaver.com
Whole thread Raw
In response to Re: create batch script to import into postgres tables  (Pepe TD Vo <pepevo@yahoo.com>)
Responses Re: create batch script to import into postgres tables
Re: create batch script to import into postgres tables
List pgsql-admin
On 6/18/20 4:37 PM, Pepe TD Vo wrote:
> thank you for the link.  I did try it and it's still error
> 
> echo 'SELECT count(*) FROM tableA;' |
> C:\Program Files\PostgreSQL\11\bin\psql -U PSmasteruser -d PSCIDR -h 
> hostname.amazonaws.com -p 5432


This is getting old. The error is?
> 
> I can run 'psql -u postgres -d PSCIDR -p 5432' (on Linux server, still 
> learning how to run it from psql shell in Window) fine from psql 
> prompt.  Just still wonder how to connect directly to the instance 
> PSCIDR from scripting in both aws and linux.  Otherwise manually run 
> using pgAdmin.
> 
> v/r,
> 
> **
> *Bach-Nga
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-admin by date:

Previous
From: Pepe TD Vo
Date:
Subject: Re: create batch script to import into postgres tables
Next
From: cgerard999@gmail.com
Date:
Subject: Re: create batch script to import into postgres tables