Re: quoting internal variable names

Ron Peterson wrote:
> Single quotes appear to behave
> differently in diffent contexts.
>
> CREATE USER
>   :v_dbadmin
> WITH PASSWORD
>   ':v_dbpass';

This sets your password to ":v_dbpass", which is probably not what you
wanted.  Your next message contains the correct solution: include the
quotes in the variable value.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/