Scripting psql for Fun and Profit

David Fetter

Monday, March 1. 2010

Scripting psql for Fun and Profit

Profit?

Yes!

Well, you can definitely lose a lot by not having things available. psql takes lots and lots of command line options. One super handy one is -v, where you can do the equivalent of a \set. For example:

psql -1 -v ON_ERROR_STOP=1 -f script.psql

makes sure that the script ends on the first error and rolls back instead of filling your screen with junk.
Posted by
David Fetter
at 21:09 | Comments (0) | Trackbacks (0)
Trackbacks
Trackback specific URI for this entry

No Trackbacks

Comments
Display comments as (Linear | Threaded)
No comments
Add Comment
Enclosing asterisks marks text as bold (*word*), underscore are made via _word_.
Standard emoticons like :-) and ;-) are converted to images.
To leave a comment you must approve it via e-mail, which will be sent to your address after submission.

To prevent automated Bots from commentspamming, please enter the string you see in the image below in the appropriate input box. Your comment will only be submitted if the strings match. Please ensure that your browser supports and accepts cookies, or your comment cannot be verified correctly.
CAPTCHA

 
   
 

Archives

Subscribe

  • XML

Blog Administration

Open login screen