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.
