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