Re: How to see a RULE definition?

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(at)Yahoo(dot)com #