Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> writes:
> But that runs a shell command, how's that supposed to get the
> search_path? I've been trying to think up a solution to that and
> can't come up with one.
Yeah, and you do *not* want the prompt mechanism trying to send SQL
commands...
regards, tom lane