how to view original source of rules?

From: Ed L(dot) <pggeneral(at)bluepolka(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: how to view original source of rules?
Date: 2002-11-26 21:08:52
Message-ID: 0211261408521L.01948@bingo
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I know about this query...

SELECT * FROM pg_rewrite where r.rulename = 'myrule';

...but the output is none too friendly to look at.

Anyone know how one can see something closer to the original input
source of a rule via psql?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2002-11-26 21:23:02 Re: how to view original source of rules?
Previous Message Nigel J. Andrews 2002-11-26 20:56:11 Re: order by in for loop in plpgsql does not work