Scripting psql for Fun and Profit

David Fetter's blog

Where I Work

PostgreSQL Experts, Inc

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 23: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 1CAPTCHA 2CAPTCHA 3CAPTCHA 4CAPTCHA 5


 
   
 

Archives

Syndicate This Blog

Blog Administration

Open login screen