Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 






--- On Thu, 2/19/09, Erik Jones <ejones@xxxxxxxxxxxxxx> wrote:

> From: Erik Jones <ejones@xxxxxxxxxxxxxx>
> Subject: Re:  How to pipe the psql copy command to Unix 'Date' command
> To: "R Smith" <4otherbusiness@xxxxxxxxxxx>
> Cc: "General postgres mailing list" <pgsql-general@xxxxxxxxxxxxxx>
> Date: Thursday, February 19, 2009, 11:08 PM
> 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
> <ejones@xxxxxxxxxxxxxx> wrote:
> >> 
> >>> From: Erik Jones <ejones@xxxxxxxxxxxxxx>
> >>> Subject: Re:  How to pipe the psql
> copy command to Unix 'Date' command
> >>> To: sharmi_jo@xxxxxxxxx
> >>> Cc: "Tom Lane"
> <tgl@xxxxxxxxxxxxx>, "General postgres mailing
> list" <pgsql-general@xxxxxxxxxxxxxx>
> >>> 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
> >>> <tgl@xxxxxxxxxxxxx> wrote:
> >>>> 
> >>>>> From: Tom Lane
> <tgl@xxxxxxxxxxxxx>
> >>>>> Subject: Re:  How to pipe the
> psql copy
> >>> command to Unix 'Date' command
> >>>>> To: sharmi_jo@xxxxxxxxx
> >>>>> Cc: "General postgres mailing
> list"
> >>> <pgsql-general@xxxxxxxxxxxxxx>
> >>>>> Date: Thursday, February 19, 2009,
> 12:31 PM
> >>>>> SHARMILA JOTHIRAJAH
> <sharmi_jo@xxxxxxxxx>
> >>> 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
> >> 
> > I've used UNIX for years and I don't know what
> you mean by 'use run full piped command'.
> > Sure I know pipes and scripting, but ?
> > I would put everything needed w/ a shell script, calls
> to java & PG, and set a var to unixtime at start and
> subtract it from the ending unixtime.
> > 
> > If nothing else, I might pick up a Linux trick!
> 
> Sorry, I'd started typing the sentence one say, back
> spaced and went to type it another and it didn't really
> come out right.  It should have been:
> 
> Run the full piped command with the unix 'time'
> utility.
> 
> I.e. if the full piped command was: cmd1 someargs | cmd2
> someargs2 | cmd3 someargs3
> 
> then run: time cmd1 someargs | cmd2 someargs2 | cmd3
> someargs3

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...
Why?

Thanks
Sharmila


      

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux