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

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
postgresusing 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?

            regards, tom lane