AJ Welch <awelch0100(at)gmail(dot)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