| From: | Richard Broersma Jr <rabroersma(at)yahoo(dot)com> |
|---|---|
| To: | Lonni J Friedman <netllama(at)gmail(dot)com> |
| Cc: | George Pavlov <gpavlov(at)mynewplace(dot)com>, pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: inserting/updating a field with the contents of a text file |
| Date: | 2007-09-25 04:08:24 |
| Message-ID: | 186548.58290.qm@web31814.mail.mud.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
--- Lonni J Friedman <netllama(at)gmail(dot)com> wrote:
> Actually the issue here is that i'm inserting build log snippets, so
> I'm never going to be 100% what will appear. Single quotes were
> definitely the issue the first time I hit this. Are there any other
> characters that are verboten, or just single quotes?
Actually, dollar sign quoting lets you create you own custom quoting character.
for example:
$my_quote$This is where the text goes$my_quote$
in this example (') is equal to ($my_quote$)
http://www.postgresql.org/docs/8.2/static/sql-syntax-lexical.html#SQL-SYNTAX-DOLLAR-QUOTING
Regards,
Richard Broersma Jr.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Broersma Jr | 2007-09-25 04:14:49 | Re: inserting/updating a field with the contents of a text file |
| Previous Message | Phillip Smith | 2007-09-25 03:18:21 | Re: inserting/updating a field with the contents of a text file |