Re: How to dump data from database?

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: go <go(at)ugnn(dot)ru>
Cc: PGSQL mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to dump data from database?
Date: 2005-04-05 03:45:45
Message-ID: 20050405034545.GA21764@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2005-04-05 04:21:54 Re: How to dump data from database?
Previous Message Greg Stark 2005-04-05 03:37:43 Re: [GENERAL] plPHP in core?