How to see a RULE definition?
От | Josh Goodman |
---|---|
Тема | How to see a RULE definition? |
Дата | |
Msg-id | Pine.GSO.4.10.10101110914250.3431-100000@helix.lanl.gov обсуждение исходный текст |
Ответы |
Re: How to see a RULE definition?
|
Список | pgsql-general |
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 по дате отправления: