AJ Welch <awelch0100@xxxxxxxxx> 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
