Re: How to dump data from database?

From: go <go(at)ugnn(dot)ru>
To: PGSQL mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to dump data from database?
Date: 2005-04-04 09:11:20
Message-ID: 15118565468.20050404131120@ugnn.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

And pls one small question - what query will return me a list
of tables in database ( \l - works only in psql)?

Thanks!

MF> On Mon, Apr 04, 2005 at 11:18:08AM +0400, go wrote:
>>
>> Tell me please is there any way to dump data from current session
>> (instead of using pg_dump) ?

MF> What exactly are you trying to do? Will COPY (or psql's \copy) do
MF> what you want?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message pck 2005-04-04 09:14:24
Previous Message Michael Fuhr 2005-04-04 07:35:05 Re: How to dump data from database?