út 2. 3. 2021 v 17:55 odesílatel Alexander Farber < alexander.far...@gmail.com> 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 > > >
