>> Le 19 juin 2020 à 17:07, Pepe TD Vo a écrit :
>>
>>
>> appreciate for clarification, all inputs and teaching me more in
>> PostgreSQL
>>
>> have a good weekend and happy father's day to all who is Father.
>>
>> v/r,
>>
>>
On 6/19/20 6:53 AM, Pepe TD Vo wrote:
> > Thank you sir and I am sorry for the typo not having "--" on
> password.
> > I did spelling out with --password=mypassword
>
> Please go back and read my post again.
>
>
> To be clear, there is
June 19, 2020, 09:19:35 AM EDT, Adrian Klaver
wrote:
On 6/19/20 4:12 AM, Pepe TD Vo wrote:
> thank you, I tried that too, remove the quote around the echo and it
> prompt for password, as I mentioned no matter I put -P mypassword no
> matter what I spell out password=mypassword stil
wrote:
Remove the quotes around echo
echo select count(*) from web_20200619; | "C:\Program
Files\postgresql\11\bin\psql" -d *** -h *** -U ***
or, store your query into a text file and use
psql -f query.sql
Sent from my mobile phone
Le 19 juin 2020 à 02:00, Adrian Klaver
generously **Care deeply **Speak kindly.*** Genuinely rich
*** Faithful talent *** Sharing success
On Thursday, June 18, 2020, 07:00:37 PM EDT, Adrian Klaver
wrote:
On 6/18/20 12:54 PM, Pepe TD Vo wrote:
>>>psql -d production -U postgres -c 'select count(*) from cell_per
(Hermione Gingold)
**Live simply **Love generously **Care deeply **Speak kindly.*** Genuinely rich
*** Faithful talent *** Sharing success
On Thursday, June 18, 2020, 03:06:39 PM EDT, Adrian Klaver
wrote:
On 6/18/20 9:40 AM, Pepe TD Vo wrote:
> I get this part that separates SQL s
:44 PM EDT, Adrian Klaver
wrote:
On 6/18/20 8:20 AM, Pepe TD Vo wrote:
Please don't top post. The preferred style on this list is inline or
bottom posting(https://en.wikipedia.org/wiki/Posting_style).
> I have a Postgresql client installed and connected. how can i create a
> batch scr
talent *** Sharing success
On Tuesday, June 16, 2020, 11:42:40 AM EDT, Pepe TD Vo
wrote:
Yes, I do have putty installed but can't connect to the aws postgres instance.
Only work for oracle instance. Only connect postgres instance using pgadmin.
follow the url and the login prompt
*** Faithful talent *** Sharing success
On Tuesday, June 16, 2020, 10:39:45 AM EDT, Adrian Klaver
wrote:
On 6/16/20 7:30 AM, Pepe TD Vo wrote:
Please post to list also.
Ccing list.
> using psql in AWS instance
> also psql in Linux. I can run psql in linux if create a batc
good morning experts,
I nêd to set up a batch script to import multi csv files to import them to
Postgres tables. Each csv files will be named table1_todaydate.csv,
table2_todaydate.csv, etc... tablen_todaydate.csv. Each csv file will import
to its table and how do I execute the script to
From: Pepe TD Vo
Sent: 31 March 2020 16:51
To: Pgsql-admin ; Pgsql-general
; PgAdmin Support List
; JC JC
Subject: Re: migrate off oracle data to postgres I have tables ddl data
definitions already. Only need to move the data over off Oracle to Postgres
Bach-Nga
No one in this world is pure
of my limited experience I never
encountered any issue on the limit on data being transferred, but definitely
the load time vary depending on the environment.
Regardsjc
From: Pepe TD Vo
Sent: 31 March 2020 15:15
To: Pgsql-admin ; Pgsql-general
; PgAdmin Support List
Subject: migrate off oracle
Hello,
I have a huge data on Oracle, would you please suggest how to migrate all data
off Oracle to Postgres? Do I need to export into csv and upload to postgres?
Ora2pg is limited data from oracle to postgresql right?
Bach-Nga
No one in this world is pure and perfect. If you avoid people
I have table and partitioned for year year like this:
CREATE TABLE ecisdrdm.bnft_curr_fact (bnft_fact_id numeric(38),
bene_cntry_of_brth_id numeric(38), bene_cntry_of_rsdc_id numeric(38),
bene_cntry_of_ctznshp_id numeric(38), frm_id numeric(38), svc_ctr_id
numeric(38), actn_dt_in_id
14 matches
Mail list logo