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

From Trewern, Ben
Subject RE: How to see a RULE definition?
Date
Msg-id 996802F75C3CD411B424001083FA445B05951E@CET_PONXX_FP001
Whole thread Raw
In response to How to see a RULE definition?  (Josh Goodman <jogoodma@lanl.gov>)
Responses RE: How to see a RULE definition?
RE: How to see a RULE definition?
List pgsql-general

You can use:
pgdump -s > outfile

which will dump all the schema for the database.
It should be in there somewhere ;)

Regards

Ben

> -----Original Message-----
> From: Josh Goodman [mailto:jogoodma@lanl.gov]
> Sent: 11 January 2001 16:16
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] How to see a RULE definition?
>
>
>
>       I am a Postgresql convert from MySQL so I am fairly new to this
> system but I am catching on quick.  I had a question that I
> couldn't find
> in any of the docs or in the FAQ's.  I was creating a rule on
> a view and
> was wondering if there was a way to look at the rule
> definition once it
> has been saved?
>
>       I envision myself creating a few rules here and there but if I
> move off this DB project and someone else takes over I would
> like them to
> have a way to see what I did.  I was able to figure out that
> all the rules
> for a particular DB are stored in the pg_rewrite table but that seems
> almost unreadable for a human.  What I would like is a
> command that spits
> out the create syntax I used when the rule was first created.  On that
> same line of thinking, is there a command to get a list of
> all rules that
> have been put on a table?
>
>       I guess if all else fails I will just have to pull up a good old
> text editor and detail exactly what rules I build in.
>
>
> Thanks,
> Josh Goodman
>
>
>

pgsql-general by date:

Previous
From: Lamar Owen
Date:
Subject: Re: PostgreSQL v7.1BETA3 Bundled and Available ...
Next
From: Tom Lane
Date:
Subject: Re: How to see a RULE definition?