Thanks all -Sharmila
--- On Thu, 2/19/09, Erik Jones <ejo...@engineyard.com> wrote: > From: Erik Jones <ejo...@engineyard.com> > Subject: Re: [GENERAL] How to pipe the psql copy command to Unix 'Date' > command > To: sharmi...@yahoo.com > Cc: "Tom Lane" <t...@sss.pgh.pa.us>, "General postgres mailing list" > <pgsql-general@postgresql.org> > 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 > <t...@sss.pgh.pa.us> wrote: > > > >> From: Tom Lane <t...@sss.pgh.pa.us> > >> Subject: Re: [GENERAL] How to pipe the psql copy > command to Unix 'Date' command > >> To: sharmi...@yahoo.com > >> Cc: "General postgres mailing list" > <pgsql-general@postgresql.org> > >> Date: Thursday, February 19, 2009, 12:31 PM > >> SHARMILA JOTHIRAJAH <sharmi...@yahoo.com> > 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 (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general