Re: [GENERAL] pg_dump

From: Sferacarta Software <sferac(at)bo(dot)nettuno(dot)it>
To: pgsql-general(at)postgresql(dot)org, System Administrator <root(at)stardust(dot)interplus(dot)ro>
Subject: Re: [GENERAL] pg_dump
Date: 1998-09-21 12:27:34
Message-ID: 18602.980921@bo.nettuno.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello System,

venerdì, 18 settembre 98, you wrote:

SA> Hi all. I am using posgresql-6.3.2 .

SA> I have the next problem : it seems that pg_dump doesn't dump views ...
SA> I'm using : pg_dump -D -z -f main.dump main
SA> to dump my database main .
SA> How can I see views in my dumps ?
SA> Is this a 'todo' ?

Yes, pg_dump fails to dump views and this is documented on man pages.
AFAIK there are also 2 data types that pg_dump doesn't understand i.e.
VARCHAR and BPCHAR if you specify it without size.

from man pg_dump:

...
rules and views
pg_dump does not understand user-defined rules and
views and will fail to dump them properly. (This
is due to the fact that rules are stored as plans
in the catalogs and not textually)
...

Jose'

In response to

  • pg_dump at 1998-09-18 15:54:47 from System Administrator

Browse pgsql-general by date

  From Date Subject
Next Message Franck SGARD 1998-09-21 13:17:40 compilation problems
Previous Message Thomas G. Lockhart 1998-09-20 23:36:53 Re: [HACKERS] Re: NOTICE: _outNode: don't know how to print type 715