On Sat, Jun 9, 2012 at 3:29 PM, David Williams
<mobiusinversion@gmail.com> wrote:
>
> Hi There,
>
> I'd like to be able to run the contents of an external SQL file from Perl. Something akin to:
>
> $dbh->do( '\i /home/david/run_me.sql' );
>
> However this fails, and I assume that is because the \i is a client command. Is there a way to run the contents of an
externalSQL from a Per database handle?
What we do in LedgerSMB is something like:
system("psql -f /home/david/run_me.sql > /tmp/dblog 2>&1") after
setting appropriate environment variables.
But if you want to do this server-side there is always pl/perlU....
Best Wishes,
Chris Travers