Re: PHP: query with parameter for SET - Mailing list pgsql-general

From Ray O'Donnell
Subject Re: PHP: query with parameter for SET
Date
Msg-id 6b74789d-abc6-24e6-ccb7-ef638e6560db@rodonnell.ie
Whole thread Raw
In response to Re: PHP: query with parameter for SET  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-general
On 27/07/2021 18:20, Pavel Stehule wrote:
> When you use client side prepared statements, then it can be possible. 
> But I don't know how it works in PHP.
> 
> Server side prepared statements are not possible in this case. "set" 
> statement has not execution plan. But you  You can use Adrian's 
> proposal, and you can prepare the query 'select set_config($1, false)'

Thanks Pavel - that makes sense.

Ray.



-- 
Raymond O'Donnell // Galway // Ireland
ray@rodonnell.ie



pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: PHP: query with parameter for SET
Next
From: Marc Millas
Date:
Subject: Re: sort order