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 20050405034545.GA21764@winnie.fuhr.org
Whole thread Raw
In response to Re: How to dump data from database?  (go <go@ugnn.ru>)
List pgsql-general
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/

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] plPHP in core?
Next
From: Michael Fuhr
Date:
Subject: Re: How to dump data from database?