On Wed, Mar 3, 2021, at 8:39 PM, PG Bug reporting form wrote:
> I'm using regex to rewrite identifiers in a SQL dump and rely on the
> double-quotes.
> Within plpgsql `CREATE FUNCTION` statements in the resulting dump,
> identifiers are not quoted as I would expect.
IIUC this is not a bug. You don't provide enough detail to show the issue. Are
you generating dynamic commands inside your PL/pgSQL function? If so, Postgres
doesn't manipulate function body. You should use quote_ident (that adds quotes
if necessary) or a similar user-defined function.
--
Euler Taveira
EDB https://www.enterprisedb.com/