Re: pg_get_triggerdef does not use the schema qualified procedure name

AJ Welch <awelch0100@gmail.com> writes:
> I noticed that pg_get_triggerdef doesn't seem to use the schema qualified
> name of procedures/functions. Is it supposed to? Is there a way to get it
> to?

Generally the policy of such functions is to schema-qualify names that
wouldn't be found in the current search_path.  So you could get what
you want by setting a restrictive search_path beforehand, maybe just ''.

            regards, tom lane