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

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