Re: validate synatax

you can use the transition.
eg:
begin;
creat table(...);
catch error if the statement not validated.
rollback;

jov
在 2013-12-11 上午5:43，"Peter Kroon" <plakroon(at)gmail(dot)com>写道：

> 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
>