"Albe Laurenz" <[EMAIL PROTECTED]> writes: > EXECUTE 'SET SESSION ROLE "' || lower(regexp_replace(wishedrole, '"', '', > 'g')) || '"';
> The "lower" and "regexp_replace" are there to prevent SQL injection.
quote_ident() would be a far better solution.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
