Postgres Pro
Downloads
Home   >   mailing lists

Re: How to pipe the psql copy command to Unix 'Date' command - Mailing list pgsql-general

From Mirko Pace
Subject Re: How to pipe the psql copy command to Unix 'Date' command
Date
Msg-id 8eae94e10902190907r497ba9eas7c5b5fbfbe49d3c5@mail.gmail.com
Whole thread Raw
In response to How to pipe the psql copy command to Unix 'Date' command  (SHARMILA JOTHIRAJAH <sharmi_jo@yahoo.com>)
List pgsql-general
Tree view
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@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

pgsql-general by date:

Previous
From: SHARMILA JOTHIRAJAH
Date:
Subject: How to pipe the psql copy command to Unix 'Date' command
Next
From: Kevin Murphy
Date:
Subject: Aliasing syntax question