Re: How to pipe the psql copy command to Unix 'Date' command - Mailing list pgsql-general

--- 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: "R Smith" <4otherbusiness@comcast.net>
> Cc: "General postgres mailing list" <pgsql-general@postgresql.org>
> Date: Thursday, February 19, 2009, 11:08 PM
> On Feb 19, 2009, at 6:30 PM, R Smith wrote:
>
> >
> > On Feb 19, 2009, at 11:07 AM, SHARMILA JOTHIRAJAH
> wrote:
> >
> >> 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
> >>
> > 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!
>
> Sorry, I'd started typing the sentence one say, back
> spaced and went to type it another and it didn't really
> come out right.  It should have been:
>
> Run the full piped command with the unix 'time'
> utility.
>
> I.e. if the full piped command was: cmd1 someargs | cmd2
> someargs2 | cmd3 someargs3
>
> then run: time cmd1 someargs | cmd2 someargs2 | cmd3
> someargs3

Is it possible to sent this 'time' output to a file...
If I try
time cmd1 someargs1 | cmd2 someargs2 > output.log

it doesn't sent the "time" to the file...
Why?

Thanks
Sharmila