Postgres Pro
Downloads
Home   >   mailing lists

Re: checking select query syntax and semantics via php without executing - Mailing list pgsql-php

From Raymond O'Donnell
Subject Re: checking select query syntax and semantics via php without executing
Date
Msg-id 4ACA6A3B.50005@iol.ie
Whole thread Raw
In response to checking select query syntax and semantics via php without executing  (Marco Dieckhoff <dieck@gmx.de>)
List pgsql-php
Tree view 
On 05/10/2009 22:34, Marco Dieckhoff wrote:

> Is it possible in PHP to give a sql (select) query to Postgres via pg_*
> so that it is NOT executed but merely checked for syntax including
> correct, existing field and table names, and data types?

How about prepending "explain" to the query? Just a wild notion.

Ray.


------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

pgsql-php by date:

Previous
From: Marco Dieckhoff
Date:
Subject: checking select query syntax and semantics via php without executing
Next
From: Bill Moran
Date:
Subject: Re: checking select query syntax and semantics via php without executing