Re: Listing views

Olivier Guilyardi <ml@xung.org> writes:
> Doug McNaught wrote:
>> 'SELECT version();' should work.  There will be no permission issues
>> with calling that function unless you set the database up that way--it
>> has PUBLIC execute permission by default.

> Good

In theory it's possible for that to fail in 7.3: if someone makes their
own function named version() and then alters the default search path so
that their function is found before the one in pg_catalog, then the
wrong function would be invoked.

In practice I'd say this falls in the category of "don't do that then".

            regards, tom lane