On Wed, 25 Jun 2014 10:09:18 -0400 Andrew Sullivan <ajs@xxxxxxxxxxxxxxx> wrote: > On Wed, Jun 25, 2014 at 02:43:25PM +0100, James Le Cuirot wrote: > > > The cookbook currently uses PQexec so multiple SQL commands are > > wrapped in a transaction unless an explicit transaction > > instruction appears. I don't want to change this behaviour but > > the only way to get exactly the same effect from psql is to use > > the -c option. > > Why not just read a file? -f filename. > > A Same problem as stdin, the transactional behaviour is different. There is the --single-transaction option but as the man page says... "If the script itself uses BEGIN, COMMIT, or ROLLBACK, this option will not have the desired effects." Regards, James
