SHARMILA JOTHIRAJAH <[email protected]> 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?
regards, tom lane
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general