Re: How to see a RULE definition? - Mailing list pgsql-general

From Jan Wieck
Subject Re: How to see a RULE definition?
Date
Msg-id 200101112019.PAA04984@jupiter.jw.home
Whole thread Raw
In response to RE: How to see a RULE definition?  (Joel Burton <jburton@scw.org>)
List pgsql-general
Joel Burton wrote:
> On Thu, 11 Jan 2001, Trewern, Ben wrote:
>
> > You can use:
> > pgdump -s > outfile
> >
> > which will dump all the schema for the database.
> > It should be in there somewhere ;)
>
> Or, for 7.1, use the new features of pg_dump to dump to the non-text-file
> formats, which will allow you instantly and selectively look at particular
> parts of your db dump, rather than worming your way through yourself.
>
> Better still:
>
> You can also SELECT * FROM pg_rules WHERE rulename='my_rule';
>
> (at least in 7.1 betas; don't remember about 7.0.x)

    Was already there - for sure.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #



pgsql-general by date:

Previous
From: Jan Wieck
Date:
Subject: Re: How to see a RULE definition?
Next
From: "Guang Mei"
Date:
Subject: How to set "auto commit" off in postgresql db?