Re: How to find the final transformed query in postgresql

2022-04-18 Thread Goti
Thanks a lot Tom. Thanks, Goti On Mon, Apr 18, 2022 at 7:43 PM Tom Lane wrote: > Goti writes: > > I would like to know if postgres performs any transformations when it > does > > the parsing? > > This might be helpful reading: > > https://www.postgresql.org/docs/current/overview.html > > >

Re: How to find the final transformed query in postgresql

2022-04-18 Thread Tom Lane
Goti writes: > I would like to know if postgres performs any transformations when it does > the parsing? This might be helpful reading: https://www.postgresql.org/docs/current/overview.html > If yes, is there a way we can get the final transformed query? See debug_print_parse and friends [1].

How to find the final transformed query in postgresql

2022-04-18 Thread Goti
Hi Geeks, Env: postgres12 I am new to postgres and coming from an Oracle background. Please excuse me if I am not asking valid questions. I would like to know if postgres performs any transformations when it does the parsing? If yes, is there a way we can get the final transformed query? Thank