Re: formatting of SQL sent by PHP to postgres

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ken Guest <kguest(at)stockbyte(dot)com>
Cc: Postgre General <pgsql-general(at)postgresql(dot)org>
Subject: Re: formatting of SQL sent by PHP to postgres
Date: 2003-10-30 15:44:37
Message-ID: 28355.1067528677@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ken Guest <kguest(at)stockbyte(dot)com> writes:
> 1. Is the semicolon at the end of SQL superflous when sent to Postgres?
> Should it make much of a difference if I removed it?

Yes; no.

> 2. A lot of SQL issued have white space characters (newlines, tabs and
> spaces) present - does this have any [major] impact on how quick
> postgres gets to execute the SQL and return results?

No. I doubt you could measure the impact at all ... unless you are
talking many kilobytes of whitespace, in which case the data
transmission overhead might be noticeable.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-10-30 15:48:48 Re: slow query performance
Previous Message scott.marlowe 2003-10-30 15:38:04 Re: Automatic auditing suggestion