Re: dollar-quoting in psql and in general

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