Re: dollar-quoting in psql and in general - Mailing list pgsql-hackers

From Tom Lane
Subject Re: dollar-quoting in psql and in general
Date
Msg-id 23795.1092281269@sss.pgh.pa.us
Whole thread Raw
In response to Re: dollar-quoting in psql and in general  (Philip Warner <pjw@rhyme.com.au>)
List pgsql-hackers
Philip Warner <pjw@rhyme.com.au> writes:
> At 12:47 PM 12/08/2004, Tom Lane wrote:
>> Backslashes are not special inside
>> dollar quotes --- nor is anything else, except the matching close tag

> If they are not special, then shouldnt:
>     select $a$\$a$;
> result in
>     ?column?
>        \
> rather than an error?

Worksforme (TM).

regression=#     select $a$\$a$;?column? 
----------\
(1 row)

regression=# 

Are you sure your psql and backend are both current?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_restore (libpq? parser?) bug in 8
Next
From: Bruce Momjian
Date:
Subject: Re: pg_dump 'die_on_errors'