On Mon, Apr 04, 2005 at 01:11:20PM +0400, go wrote: > > I would like to "pg_dump -Fc MyDataBase>archiv.dat" ( maybe there is > any SQL command or something else) . > in case with COPY command I have to copy each table one by one. I suppose you could write a function in a procedural language like PL/Perl, PL/Python, or PL/Tcl that runs pg_dump, but why do you need to do this from SQL? Why can't you just run pg_dump from outside the database? -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
