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

2009-03-02 Thread Alan Hodgson
On Monday 02 March 2009, John R Pierce wrote: > SHARMILA JOTHIRAJAH wrote: > > Is it possible to sent this 'time' output to a file... > > If I try > > time cmd1 someargs1 | cmd2 someargs2 > output.log > > > > it doesn't sent the "time" to the file... > > time (cmd1 someargs1 | cmd2 someargs2) > ou

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

2009-03-02 Thread John R Pierce
SHARMILA JOTHIRAJAH wrote: Is it possible to sent this 'time' output to a file... If I try time cmd1 someargs1 | cmd2 someargs2 > output.log it doesn't sent the "time" to the file... time (cmd1 someargs1 | cmd2 someargs2) > output.log the way you had it, it was only timing cmd1. with the

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

2009-03-02 Thread SHARMILA JOTHIRAJAH
--- On Thu, 2/19/09, Erik Jones wrote: > From: Erik Jones > Subject: Re: [GENERAL] How to pipe the psql copy command to Unix 'Date' > command > To: "R Smith" <4otherbusin...@comcast.net> > Cc: "General postgres mailing list" > Date: T

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

2009-02-19 Thread Erik Jones
On Feb 19, 2009, at 6:30 PM, R Smith wrote: On Feb 19, 2009, at 11:07 AM, SHARMILA JOTHIRAJAH wrote: Thanks all -Sharmila --- On Thu, 2/19/09, Erik Jones wrote: From: Erik Jones Subject: Re: [GENERAL] How to pipe the psql copy command to Unix 'Date' command To: sharmi...

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

2009-02-19 Thread R Smith
On Feb 19, 2009, at 11:07 AM, SHARMILA JOTHIRAJAH wrote: Thanks all -Sharmila --- On Thu, 2/19/09, Erik Jones wrote: From: Erik Jones Subject: Re: [GENERAL] How to pipe the psql copy command to Unix 'Date' command To: sharmi...@yahoo.com Cc: "Tom Lane" , "Gene

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

2009-02-19 Thread SHARMILA JOTHIRAJAH
Thanks all -Sharmila --- On Thu, 2/19/09, Erik Jones wrote: > From: Erik Jones > Subject: Re: [GENERAL] How to pipe the psql copy command to Unix 'Date' > command > To: sharmi...@yahoo.com > Cc: "Tom Lane" , "General postgres mailing list" &g

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

2009-02-19 Thread Erik Jones
On Feb 19, 2009, at 9:40 AM, SHARMILA JOTHIRAJAH wrote: --- On Thu, 2/19/09, Tom Lane wrote: From: Tom Lane Subject: Re: [GENERAL] How to pipe the psql copy command to Unix 'Date' command To: sharmi...@yahoo.com Cc: "General postgres mailing list" Date: Thursday, F

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

2009-02-19 Thread SHARMILA JOTHIRAJAH
--- On Thu, 2/19/09, Tom Lane wrote: > From: Tom Lane > Subject: Re: [GENERAL] How to pipe the psql copy command to Unix 'Date' > command > To: sharmi...@yahoo.com > Cc: "General postgres mailing list" > Date: Thursday, February 19, 2009, 12:31 PM

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

2009-02-19 Thread Tom Lane
SHARMILA JOTHIRAJAH 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

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

2009-02-19 Thread Mirko Pace
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 wrote: > Hi, > I want to find the time taken by this process ...retrieving data from > oracle database using java and copying that to postgres

[GENERAL] How to pipe the psql copy command to Unix 'Date' command

2009-02-19 Thread SHARMILA JOTHIRAJAH
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 outp