pg_dump query about views

From: "Colin Price (EML)" <Colin(dot)Price(at)eml(dot)ericsson(dot)se>
To: pgsql-general(at)postgreSQL(dot)org
Subject: pg_dump query about views
Date: 1999-02-12 11:49:16
Message-ID: 5F052F2A01FBD11184F00008C7A4A800019432BC@eukbant101.ericsson.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Browse pgsql-general by date

  From Date Subject
Next Message Bill Sneed 1999-02-12 12:58:22 Re: [NOVICE] Re: Subject: Re: [GENERAL] A book for PgSQL? A need? yes? no?
Previous Message Oleg Broytmann 1999-02-12 11:24:43 Re: [GENERAL] Problems compiling