Why not call a function that make an insert as "insert into dummy values ('Start',now())" ?
Mirko On Thu, Feb 19, 2009 at 5:37 PM, SHARMILA JOTHIRAJAH <sharmi...@yahoo.com>wrote: > 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 > > 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 > > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >