validate synatax

From: Peter Kroon <plakroon(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: validate synatax
Date: 2013-12-10 21:40:19
Message-ID: CAOh+DO=xw-Ps3MGD1-D7i2X7cyd7hjXUokcxqv9_+Dk8gnfn6A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

How can I validate any query on PostgreSQL without executing the sql.
I was able with EXPLAIN to find some errors. However this only worked with
a SELECT statement. When i tried to create a TABLE it would not run.
I do not wish to install external packages. Preferably use only default
present features.

http://wiki.postgresql.org/wiki/Introduction_to_VACUUM,_ANALYZE,_EXPLAIN,_and_COUNT#PostgreSQL_EXPLAIN

Any suggestions are welcome.

Best,
Peter

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Szymon Guz 2013-12-10 21:44:55 Re: validate synatax
Previous Message Kevin Grittner 2013-12-10 21:04:05 Re: Q: regarding backends