Re: [HACKERS] Dumping of views -- done!

Hi Bruce

On Sat, 3 Oct 1998, Bruce Momjian wrote:

> > Hi all
> >
> > Is it too late to add a feature to pg_dump for 6.4??

> I though we dumped views already.  If not, I am inclinded to apply it,

OH, ... well, if it does, I sure would like to know how, I missed it.

> but want to see what others say.  I thought Jan was working on this, or
> was that just rewrite rules?  Are you using his code?  I know there is

I tryed to stay as much in style with the code that was there as possible.

> an item on the Open Items list that talks about this:
>
>     have psql dump out rules text with new function
> Is that what this is?

I'm not sure that is the same, what my change does is add:
CREATE VIEW viewname AS select clause......;
to the dump file.

I did notice that if used with '-z' it also puts the revoke grant
statments there too.  Not my doing, just nice.

At this time there are no provisions (by me any way) to dump any
associated update/delete rules on the view.  Unless, like -z above, it
already works?

To the best of my knowlage this feature does not yet exist, if any one
else is working on it, I don't know.

> --
>   Bruce Momjian                        |  http://www.op.net/~candle
>   maillist@candle.pha.pa.us            |  (610) 853-3000
>   +  If your life is a hard drive,     |  830 Blythe Avenue
>   +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
>

Have a great day
Terry Mackintosh <terry@terrym.com>          http://www.terrym.com
sysadmin/owner  Please! No MIME encoded or HTML mail, unless needed.

Proudly powered by R H Linux 4.2, Apache 1.3, PHP 3, PostgreSQL 6.3
-------------------------------------------------------------------
Success Is A Choice ... book by Rick Patino, get it, read it!