"Pretend" update - Mailing list pgsql-general

From Perry Smith
Subject "Pretend" update
Date
Msg-id 1444DFEC-2E77-482C-8068-A180BDC8D3B3@gmail.com
Whole thread Raw
Responses Re: "Pretend" update  (Adrian Klaver <adrian.klaver@gmail.com>)
List pgsql-general
With "make" I can do "make -n" and it just tells me what it would do but doesn't actually do anything.

How could I do that with SQL?

I want to write a really complicated (for me) SQL UPDATE statement.  I'm sure I won't get it right the first time.  Is
therean easy way to not really make the changes? 

I've thought about starting a transaction and then roll it back.  That would undo the changes.  But I won't be able to
tellwhat the changes were. 

Thank you for your time,
Perry


Attachment

pgsql-general by date:

Previous
From: Carlos Eduardo Sotelo Pinto
Date:
Subject: Help on ṕerformance
Next
From: Adrian Klaver
Date:
Subject: Re: "Pretend" update