Re: Feature request: include script file into function body - Mailing list pgsql-bugs

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