Re: problem with serial

From: Chris Angelico <rosuav(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: problem with serial
Date: 2012-04-19 23:58:28
Message-ID: CAPTjJmp_p2-55746-kmSSiAzuVmHFvxYqEKiXuuA6iv6ixL9vg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Apr 20, 2012 at 5:33 AM, Raymond O'Donnell <rod(at)iol(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tatsuo Ishii 2012-04-20 00:22:38 Re: pgpool2 master fail problem
Previous Message Yvon Thoraval 2012-04-19 19:49:53 Re: problem with serial