Re: How to pipe the psql copy command to Unix 'Date' command

--- On Thu, 2/19/09, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
> Subject: Re: [GENERAL] How to pipe the psql copy command to Unix 'Date' command
> To: sharmi_jo(at)yahoo(dot)com
> Cc: "General postgres mailing list" <pgsql-general(at)postgresql(dot)org>
> Date: Thursday, February 19, 2009, 12:31 PM
> SHARMILA JOTHIRAJAH <sharmi_jo(at)yahoo(dot)com> 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