Search Postgresql Archives

Re: Localizing stored functions by replacing placeholders in their body

Subject: Re: Localizing stored functions by replacing placeholders in their body
From: Alexander Farber <alexander.farber@xxxxxxxxx>
Date: Tue, 2 Mar 2021 18:30:23 +0100
Cc: pgsql-general <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to: <CAADeyWgx5bEw2xu5DveHH8K6xtvm+voPJuP1gQF+6jdYH=TJDw@mail.gmail.com>
References: <CAADeyWiVL-N0XPipT--ypL5BzCnpSe6+c8RdHaKnx6u6PoHqJA@mail.gmail.com> <938715.1614698875@sss.pgh.pa.us> <CAADeyWirC2phhvAs1fagnOr1zDxCx+RRzZ+1yCym3FfTO2jVbQ@mail.gmail.com> <CAADeyWjCFs78-J-cv+9v4Du5nceuGWan=nmWqGHqVJqi_BxkCw@mail.gmail.com> <CAFj8pRDRrR9UDYuvYLxHu=659DW1kxTa7m7wPVLoipj8fg2kOQ@mail.gmail.com> <CAADeyWgrj0JOMJ9cvkketbQ9QCkshJjvGRc9fQQh0WzzsZKN0Q@mail.gmail.com> <CAFj8pRD3K8NfoxLCEEnnqirJgkYRXPj2MD2=Le2o1xRu+FT24A@mail.gmail.com> <CAADeyWgx5bEw2xu5DveHH8K6xtvm+voPJuP1gQF+6jdYH=TJDw@mail.gmail.com>

I think I will try this approach:

\set localized_declaration `sed 's/this/that/' my_func.sql`

:localized_declaration

Thank you for your input

References:
- Localizing stored functions by replacing placeholders in their body
  - From: Alexander Farber
- Re: Localizing stored functions by replacing placeholders in their body
  - From: Tom Lane
- Re: Localizing stored functions by replacing placeholders in their body
  - From: Alexander Farber
- Re: Localizing stored functions by replacing placeholders in their body
  - From: Alexander Farber
- Re: Localizing stored functions by replacing placeholders in their body
  - From: Pavel Stehule
- Re: Localizing stored functions by replacing placeholders in their body
  - From: Alexander Farber
- Re: Localizing stored functions by replacing placeholders in their body
  - From: Pavel Stehule
- Re: Localizing stored functions by replacing placeholders in their body
  - From: Alexander Farber