[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] how to use pg_dump and then restored onto development server
From:       Matt Van Mater <matt.vanmater () gmail ! com>
Date:       2005-06-30 17:25:38
Message-ID: 424db35505063010251b2cfd07 () mail ! gmail ! com
[Download RAW message or body]

On 6/29/05, Douglas McNaught <doug@mcnaught.org> wrote:
> "Zlatko Matic" <zlatko.matic1@sb.t-com.hr> writes:
> 
> > OK..i get it. It works...
> > My additional question is: how to incorporate timestamp in dumped file
> > name ?
> > Let's say, if we have script: pg_dump -f D:\MYDB_BCP -Fc -c -x -h
> > localhost -U postgres MYDB,
> > so that output file is named something like MYDB_BCP_2005-29-01, for
> > example. Is that possible?
> 
> I'm sure it's possible, but I'm not an expert on Windows batch command
> language.  There are some good references for that stuff on the
> web--check them out.
> 

To get the date in a format that should work for you in win2000 and
winxp, open a command prompt and type the following command:
FOR /F "tokens=2-4 delims=/ " %f IN ('date /t') DO (echo %h-%g-%f)

To get the same date format inside a .bat batch script, replace each %
sign with two % signs, like this:
FOR /F "tokens=2-4 delims=/ " %%f IN ('date /t') DO (echo %%h-%%g-%%f)

You can run a similar command to get the current timestamp as well. 
For more information on how to do this, and to better understand the
commands above, open a command prompt and type "for /?"... you will
see a help screen on the FOR construct in the windows command shell.

enjoy:)

Matt

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

[prev in list] [next in list] [prev in thread] [next in thread]