--- 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
Thanks
Sharmila
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
