| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Pepe TD Vo <pepevo(at)yahoo(dot)com>, Christopher Browne <cbbrowne(at)gmail(dot)com> |
| Cc: | Pgsql-admin <pgsql-admin(at)postgresql(dot)org>, Pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: create batch script to import into postgres tables |
| Date: | 2020-06-19 00:00:04 |
| Message-ID: | 37a9ad71-b297-96b3-9c1f-1043e75dec58@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
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(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | cgerard999 | 2020-06-19 01:25:21 | Re: create batch script to import into postgres tables |
| Previous Message | Pepe TD Vo | 2020-06-18 23:37:48 | Re: create batch script to import into postgres tables |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | cgerard999 | 2020-06-19 01:25:21 | Re: create batch script to import into postgres tables |
| Previous Message | Pepe TD Vo | 2020-06-18 23:37:48 | Re: create batch script to import into postgres tables |