RE: How to see a RULE definition?

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)

--
Joel Burton   <jburton@scw.org>
Director of Information Systems, Support Center of Washington