Dry-Run Postgresql Commands

Simply include rollback as part of the transaction.

BEGIN;

UPDATE "Order" as o  
SET type = 'PREMIUM'  
FROM "UserOrders" as uo  
WHERE uo."OrderId" = o.id  
AND o.type = 'STARTUP';

SELECT count(o.type) FROM "Orders" as o,  
"UserOrders" as uo WHERE uo."OrderId" = o.id
AND o.type = 'STARTUP';

ROLLBACK;

Seah Ying Cong

Old soul in an older body.

Subscribe to Ying Cong

Get the latest posts delivered right to your inbox.

or subscribe via RSS with Feedly!