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(at)scw(dot)org>
Director of Information Systems, Support Center of Washington