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

Thanks all
-Sharmila


--- On Thu, 2/19/09, Erik Jones <ejones@engineyard.com> wrote:

> From: Erik Jones <ejones@engineyard.com>
> Subject: Re: [GENERAL] How to pipe the psql copy command to Unix 'Date' command
> To: sharmi_jo@yahoo.com
> Cc: "Tom Lane" <tgl@sss.pgh.pa.us>, "General postgres mailing list" <pgsql-general@postgresql.org>
> 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@sss.pgh.pa.us> wrote:
> >
> >> From: Tom Lane <tgl@sss.pgh.pa.us>
> >> Subject: Re: [GENERAL] How to pipe the psql copy
> command to Unix 'Date' command
> >> To: sharmi_jo@yahoo.com
> >> Cc: "General postgres mailing list"
> <pgsql-general@postgresql.org>
> >> Date: Thursday, February 19, 2009, 12:31 PM
> >> SHARMILA JOTHIRAJAH <sharmi_jo@yahoo.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
>
> Tom just showed you how.  Use run full piped command with
> the unix 'time' utility.
>
> Erik Jones, Database Administrator
> Engine Yard
> Support, Scalability, Reliability
> 866.518.9273 x 260
> Location: US/Pacific
> IRC: mage2k