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

[Mirko Pace <mirkop82@xxxxxxxxx>]

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_jo@xxxxxxxxx> 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general