Home > mailing lists

validate synatax - Mailing list pgsql-general

From	Peter Kroon
Subject	validate synatax
Date	December 11, 2013 00:40:27
Msg-id	CAOh+DO=xw-Ps3MGD1-D7i2X7cyd7hjXUokcxqv9_+Dk8gnfn6A@mail.gmail.com Whole thread Raw
Responses	Re: validate synatax (Szymon Guz <mabewlun@gmail.com>) Re: validate synatax (Jerry Sievers <gsievers19@comcast.net>) Re: validate synatax (Jov <zhao6014@gmail.com>)
List	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.

Any suggestions are welcome.

Best,

Peter

From: Kevin Grittner
Date: 11 December 2013, 00:07:06
Subject: Re: Q: regarding backends

From: Szymon Guz
Date: 11 December 2013, 00:45:00
Subject: Re: validate synatax