Re: how to use pg_dump and then restored onto development server
От | Zlatko Matic |
---|---|
Тема | Re: how to use pg_dump and then restored onto development server |
Дата | |
Msg-id | 001801c57e12$880f91c0$b8851dc3@zlatko58zaczpv обсуждение исходный текст |
Ответ на | how to use pg_dump and then restored onto development server (ketan shah <ketan_dba@yahoo.com>) |
Список | pgsql-general |
thanks. ----- Original Message ----- From: "Matt Van Mater" <matt.vanmater@gmail.com> To: "Zlatko Matic" <zlatko.matic1@sb.t-com.hr> Cc: <pgsql-general@postgresql.org> Sent: Thursday, June 30, 2005 7:25 PM Subject: Re: [GENERAL] how to use pg_dump and then restored onto development server 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
В списке pgsql-general по дате отправления: