Again, apologies if this is a duplication from the past but I can't it in
pgsql-questions :
-------------------------------
In the reference section, it states there are problems with dumping views
and rules. A pg_dumpall/pg_dump stores the view as a table with a rule.
Therefore, when loaded back in, the view is now a table and not loaded into
pg_view.
To change this, do I create a simple script to remove the 'CREATE TABLE' and
transform the 'CREATE RULE' into a create view statement>
---------------------------------
As always, thank you in advance,
Colin PRICE.