Thanks all -Sharmila
--- On Thu, 2/19/09, Erik Jones <[email protected]> wrote: > From: Erik Jones <[email protected]> > Subject: Re: [GENERAL] How to pipe the psql copy command to Unix 'Date' > command > To: [email protected] > Cc: "Tom Lane" <[email protected]>, "General postgres mailing list" > <[email protected]> > Date: Thursday, February 19, 2009, 1:31 PM > On Feb 19, 2009, at 9:40 AM, SHARMILA JOTHIRAJAH wrote: > > > --- On Thu, 2/19/09, Tom Lane > <[email protected]> wrote: > > > >> From: Tom Lane <[email protected]> > >> Subject: Re: [GENERAL] How to pipe the psql copy > command to Unix 'Date' command > >> To: [email protected] > >> Cc: "General postgres mailing list" > <[email protected]> > >> Date: Thursday, February 19, 2009, 12:31 PM > >> 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? > >> > >> > > No...I would definitely prefer to get the time elapsed > between the start of the java program and the end of the > copy command... Is that possible ? If not at least the start > and the end time so tht i can do the calculation myself > > Tom just showed you how. Use run full piped command with > the unix 'time' utility. > > Erik Jones, Database Administrator > Engine Yard > Support, Scalability, Reliability > 866.518.9273 x 260 > Location: US/Pacific > IRC: mage2k -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
