Why is this handy? Well updating your SVN repo to execute new code w/o having to leave vsql or open another prompt.
Example 1: Get your working directory
Code: Select all
datawhisperer=> \! pwd
/home/datawhisperer
Code: Select all
datawhisperer=> \! svn up /home/datawhisperer/sql
Authentication realm: <https://svn.datawhisperer.com:443> Datawhisperer.com Subversion server
Password for 'datawhisperer':
-----------------------------------------------------------------------
Store password unencrypted (yes/no)? no
U /home/datawhisperer/sql/scheduled-scripts/script-to-execute.sql