Re: formatting of SQL sent by PHP to postgres - Mailing list pgsql-general

From Tom Lane
Subject Re: formatting of SQL sent by PHP to postgres
Date
Msg-id 28355.1067528677@sss.pgh.pa.us
Whole thread Raw
In response to formatting of SQL sent by PHP to postgres  (Ken Guest <kguest@stockbyte.com>)
List pgsql-general
Ken Guest <kguest@stockbyte.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

pgsql-general by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: slow query performance
Next
From: Tom Lane
Date:
Subject: Re: dump schema schema only?