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.
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 |