David G. Johnston wrote: > In hindsight I'm not surprised but couldn't find a ready explanation on the web and > figured I'd inquire here. In short: "export VAR" and "export -f functionname" behave > differently when psql is acting as a relay.
It works for me on Linux with 9.6.3 psql:
Except you haven't recreated the scenario I presented.
You only are involving a single script and that script defines "testfunction" itself (which makes exporting pointless). In my example the script being executed within the psql script does not define testfunction itself.