Thread: pg_dump

Hi all. I am using posgresql-6.3.2 .

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


George.

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'