Postgres Pro
Downloads
Home   >   mailing lists

Thread: Printf-like function

Printf-like function

From
Igor Korot
Date:
Hi, ALL,
Is there a printf-lilke function inside libpq that can be used
to create a proper query string with the proper quoting of the
literal?

Or I will need to use sprintf()?

Thank you.

Re: Printf-like function

From
Tom Lane
Date:
Igor Korot <ikorot01@gmail.com> writes:
> Is there a printf-lilke function inside libpq that can be used
> to create a proper query string with the proper quoting of the
> literal?

No.  You'd be better off to transmit the literal value as a
parameter.

            regards, tom lane

Re: Printf-like function

From
Igor Korot
Date:
Thank you.

On Fri, Nov 11, 2022 at 11:12 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> Igor Korot <ikorot01@gmail.com> writes:
> > Is there a printf-lilke function inside libpq that can be used
> > to create a proper query string with the proper quoting of the
> > literal?
>
> No.  You'd be better off to transmit the literal value as a
> parameter.
>
>                         regards, tom lane