Re: Localizing stored functions by replacing placeholders in their body

[Pavel Stehule <pavel.stehule@xxxxxxxxx>]

út 2. 3. 2021 v 17:55 odesílatel Alexander Farber <alexander.farber@xxxxxxxxx> napsal:

Thank you for the \! hint, Pavel, didn't know about that!

Is it possible to have a pure SQL solution? (To avoid having to install "sed" on my Win 10 PC)

You should to use PLpgSQL EXECUTE statement, not SQL statement

https://www.postgresql.org/docs/current/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN

But I don't know - all this is server side, and you do some things on client side

Maybe by using EXECUTE?

EXECUTE REGEXP_REPLACE(

$localize$

CREATE OR REPLACE FUNCTION my_func()

        RETURNS text AS

$func$

        SELECT '$(placeholder)';

$func$ LANGUAGE sql IMMUTABLE;

$localize$, '\$\(\w+\)', 'English word', 'g');

Unfortunately, I get the error:

ERROR:  prepared statement "regexp_replace" does not exist