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 23348.1092278835@sss.pgh.pa.us
Whole thread Raw
In response to dollar-quoting in psql and in general  (Philip Warner <pjw@rhyme.com.au>)
Responses Re: dollar-quoting in psql and in general  (Philip Warner <pjw@rhyme.com.au>)
List pgsql-hackers
Philip Warner <pjw@rhyme.com.au> writes:
> While trying to understand dollar-quoting, I found the following in psql:
>     select $a$ hello $a$;

> behaves as expected, but psql does not like

>     select $a$ \ $a$;
> or
>     select $a$ \\ $a$;

Define "does not like".  The behavior seems correct to me.

> Should it? How should a dollar-quote handle:
>     $a$ \$a\$a $a$

The value of that is " \$a\$a ".  Backslashes are not special inside
dollar quotes --- nor is anything else, except the matching close tag.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_restore (libpq? parser?) bug in 8
Next
From: Tom Lane
Date:
Subject: Re: pg_restore (libpq? parser?) bug in 8