AJ Welch <awelch0...@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
