Re: create batch script to import into postgres tables

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