| 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: | Whole Thread | Raw Message | 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 |