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
