Is there an option that can change the "exit external editor -> query runs automatically" behaviour of the psql \e switch ? (Other than intentionally mangling the query syntax).
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
Don't add a semicolon (
If you have many request and some semicolons use Transaction :
In psql open editor mode
Back to psql : your requests are executed but change are not written :
If all is OK, save changes with :
else If you have errors or want to cancel :
You can always prefix the query with the postgres comment string:
and the query will not run but will be available in the psql deadline history buffer for editing.