Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
> I tried creating a rule like:
> create rule "_RETURN" as on select to asfd do instead select * from blah;
> And it worked.
> But it doesn't appear in pg_rules.
That's by design. pg_rules suppresses view rules. You'll find asfd in
pg_views, instead.
regards, tom lane