[GENERAL] ERROR: syntax error at or near ":"

[Graham Leggett]

Hi all,

I have a text file, and I need to update the value of an element in a table 
with the contents of this text file. Following the instructions at 
http://stackoverflow.com/questions/10968039/postgresql-inserting-value-of-a-column-from-a-file
 I tried this, but get the error below, which I do not understand.

Can anyone explain what might be going wrong, and what I should do instead?

patricia=# \set content `cat /tmp/certificates.txt`
patricia=# update property set value = :'content' where key = 
'patricia.home.security.cacerts';
ERROR:  syntax error at or near ":"
LINE 1: update property set value = :'content' where key = 'patricia...
                                    ^

Regards,
Graham
--

smime.p7s
Description: S/MIME cryptographic signature