Re: problem with serial - Mailing list pgsql-general

From Chris Angelico
Subject Re: problem with serial
Date
Msg-id CAPTjJmp_p2-55746-kmSSiAzuVmHFvxYqEKiXuuA6iv6ixL9vg@mail.gmail.com
Whole thread Raw
In response to Re: problem with serial  (Raymond O'Donnell <rod@iol.ie>)
List pgsql-general
On Fri, Apr 20, 2012 at 5:33 AM, Raymond O'Donnell <rod@iol.ie> wrote:
> Yep - no need to worry about quoting if you use parameters - it's all
> done for you. It's also MUCH safer, as it makes SQL injection attacks
> much harder (if not impossible).

And in some cases, it can even be more bandwidth-efficient. I don't
know if PDO can take advantage of this, but with the
PostgreSQL-specific functions (pg_query_params etc), an alternative
protocol method is used that sends the query and its parameters
separately, to great efficiency.

ChrisA

pgsql-general by date:

Previous
From: Yvon Thoraval
Date:
Subject: Re: problem with serial
Next
From: Tatsuo Ishii
Date:
Subject: Re: pgpool2 master fail problem