On Jun 18, 2005, at 7:27 AM, Benjamin Smith wrote:
I wrote a rule a while back that, due to the software being
extended, now
needs to be deleted.
How do I drop a rule?
http://www.postgresql.org/docs/8.0/interactive/sql-droprule.html
DELETE FROM pg_rules WHERE rulename='foo';
doesn't seem to cut it...
In general, you don't probably want to be mucking around in the
system catalog (the pg_* tables) unless you know what you're doing.
Most of the things that need to be done have specific commands so you
don't have to work with the system tables directly.
You'll also probably find the SQL Command Reference page helpful.
http://www.postgresql.org/docs/8.0/interactive/sql-commands.html
Hope this helps.
Michael Glaesemann
grzm myrealbox com
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
