Re: Run statements before pg_dump in same transaction?

[John R Pierce <pierce@xxxxxxxxxxxx>]

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