Re: Extract constants from EXECUTE queries

On 11/12/24 12:28, ISHAN CHHANGANI wrote: > Hi hackers, I wanted to extract constants hard coded within prepared > statements. > > ex:- > >   > > PREPARE stmt(text, int) as SELECT * FROM test_table WHERE a = $1 AND b = > 99 AND c = $2; > > EXECUTE stmt('abc', 1); > >   > > I can easily get th

Extract constants from EXECUTE queries

Hi hackers, I wanted to extract constants hard coded within prepared statements. ex:- PREPARE stmt(text, int) as SELECT * FROM test_table WHERE a = $1 AND b = 99 AND c = $2; EXECUTE stmt('abc', 1); I can easily get the parameter values ('abc' and 1) from queryDesc->params, but I need to also ex