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  wrote:
>
>> From: Tom Lane 
>> Subject: Re: [GENERAL] How to pipe the psql copy command to Unix  
>> 'Date' command
>> To: sharmi_jo@yahoo.com
>> Cc: "General postgres mailing list" 
>> Date: Thursday, February 19, 2009, 12:31 PM
>> SHARMILA JOTHIRAJAH  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