Re: [psycopg] Solving the SQL composition problem - Mailing list psycopg

From Christophe Pettus
Subject Re: [psycopg] Solving the SQL composition problem
Date
Msg-id 0A40E4F5-C5D4-480D-BD90-40BC1253278C@thebuild.com
Whole thread Raw
In response to Re: [psycopg] Solving the SQL composition problem  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
List psycopg
> On Jan 3, 2017, at 08:24, Jim Nasby <Jim.Nasby@BlueTreble.com> wrote:
> What I'm suggesting is to let Postgres handle the replacement of normal values, using the prepared statement syntax
of$1, $2, etc[1], and only do identifier replacement in python (using quote_ident).  

If this is practical, I'd be very much in favor of it, for the reasons given.

--
-- Christophe Pettus
   xof@thebuild.com



psycopg by date:

Previous
From: Daniele Varrazzo
Date:
Subject: Re: [psycopg] Solving the SQL composition problem
Next
From: Daniele Varrazzo
Date:
Subject: Re: [psycopg] Solving the SQL composition problem