Re: validate synatax

Perhaps creating a temporary table would be more efficient.
Then the rollback isn't necessary.

2013/12/11 Jov <zhao6014(at)gmail(dot)com>

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