Re: How to dump data from database?

[Please copy the mailing list on replies.]

On Tue, Apr 05, 2005 at 08:07:47AM +0400, go wrote:
> MF> 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.
>
> MF> I suppose you could write a function in a procedural language like
> MF> PL/Perl, PL/Python, or PL/Tcl that runs pg_dump, but why do you
> MF> need to do this from SQL?  Why can't you just run pg_dump from
> MF> outside the database?
>
> Pls, write a small sample of the function .

Could you tell us why you want to run pg_dump from SQL?  What problem
are you trying to solve?

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/