>
>> 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 no
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
old)
**Live simply **Love 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 '
l, he was a perfect gentleman (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
18, 2020, 12:08: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 crea
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 promp
peak kindly.*** Genuinely rich
*** 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
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 call
ersjc
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 pur
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 fo
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 numer
14 matches
Mail list logo
