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

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!

Thanks,
Ralph Smith