Re: Run statements before pg_dump in same transaction?

On 3/23/2017 12:06 PM, François Beausoleil wrote:
> BEGIN;
> UPDATE users SET email = 'dev+' || id || '@example.com', password_hash = '/* hash of "password" */', ...;
> -- launch pg_dump as usual, ensuring a ROLLBACK at the end
> -- pg_dump must run with the*same* connection, obviously
>
> -- if not already done by pg_dump
> ROLLBACK;

there is no way to get pg_dump to use the same connection as your
script.... its a standalone program, and will open its own connection,
hence run its own transactions.

--
john r pierce, recycling bits in santa cruz