ERROR: syntax error at or near ":"

From: Graham Leggett <minfrin(at)sharp(dot)fm>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: ERROR: syntax error at or near ":"
Date: 2013-03-06 22:41:48
Message-ID: D60E06BC-D18B-4AB9-A70E-AF1326CA7EB0@sharp.fm
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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
--

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Greg Williamson 2013-03-06 23:04:15 Re: ERROR: syntax error at or near ":"
Previous Message ning chan 2013-03-06 22:38:41 Re: WAL_DEBUG