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
so that the output is like this
Start_time 2009-02-19 11:30:15
End_time 2009-02-19 11:40:15
This should give me the time this process started and the time it ended. Is that possible?
Thanks
Sharmila