On Feb 19, 2009, at 11:07 AM, SHARMILA JOTHIRAJAH wrote:
Thanks all
-Sharmila
--- On Thu, 2/19/09, Erik Jones <ejones@xxxxxxxxxxxxxx> wrote:
From: Erik Jones <ejones@xxxxxxxxxxxxxx>
Subject: Re: How to pipe the psql copy command to Unix
'Date' command
To: sharmi_jo@xxxxxxxxx
Cc: "Tom Lane" <tgl@xxxxxxxxxxxxx>, "General postgres mailing list"
<pgsql-general@xxxxxxxxxxxxxx>
Date: Thursday, February 19, 2009, 1:31 PM
On Feb 19, 2009, at 9:40 AM, SHARMILA JOTHIRAJAH wrote:
--- On Thu, 2/19/09, Tom Lane
<tgl@xxxxxxxxxxxxx> wrote:
From: Tom Lane <tgl@xxxxxxxxxxxxx>
Subject: Re: How to pipe the psql copy
command to Unix 'Date' command
To: sharmi_jo@xxxxxxxxx
Cc: "General postgres mailing list"
<pgsql-general@xxxxxxxxxxxxxx>
Date: Thursday, February 19, 2009, 12:31 PM
SHARMILA JOTHIRAJAH <sharmi_jo@xxxxxxxxx>
writes:
Hi,
I want to find the time taken by this process
...retrieving data from oracle database using java
and
copying that to postgres using copy.
So I need something like this
Start_Time|java testCode ...|psql -c
"copy dummy
from stdin with delimiter ',' null
'NULL'" test| End_time
time java testCode ...|psql -c "copy dummy
from stdin
with delimiter ',' null
'NULL'" test
Or do you really insist on doing the timestamp
subtraction
by hand?
No...I would definitely prefer to get the time elapsed
between the start of the java program and the end of the
copy command... Is that possible ? If not at least the start
and the end time so tht i can do the calculation myself
Tom just showed you how. Use run full piped command with
the unix 'time' utility.
Erik Jones, Database Administrator
I've used UNIX for years and I don't know what you mean by 'use run
full piped command'.
Sure I know pipes and scripting, but ?
I would put everything needed w/ a shell script, calls to java & PG,
and set a var to unixtime at start and subtract it from the ending
unixtime.
If nothing else, I might pick up a Linux trick!
Thanks,
Ralph Smith
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
