On 2011-02-02, Steve White <swhite@aip.de> wrote:
> Hi, Robert,
>
> I made a file 'yadda_yadda.py' containing only the line:
> print 'hello world'
>
>====================================================================
> d=# \set yadda `cat yadda_yadda.py`
> d=# \echo :yadda
> print 'hello world'
>====================================================================
> But the :'yadda'; produces an error--it seems the variable yadda isn't
> expanded in the presence of the quotes.
yes, \set doesn't quote content
\set yadda '''' `sed -e "s/'/''/g" -e 's/\\/\\\\/g' < yadda_yadda.py` ''''
CREATE FUNCTION yadda_yadda() returns text language plpythonu AS
E:yadda;
this is not much help for windows users though.
BTW I found that sed command on the psql man page.
--
ââ 100% natural