Re: How to dump data from database? - Mailing list pgsql-general

From Michael Fuhr
Subject Re: How to dump data from database?
Date
Msg-id 20050405042154.GA22071@winnie.fuhr.org
Whole thread Raw
In response to How to dump data from database?  (go <go@ugnn.ru>)
Responses Re: How to dump data from database?
List pgsql-general
[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/

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: How to dump data from database?
Next
From: Neil Conway
Date:
Subject: Re: Regarding niladic functions