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