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'