Perhaps creating a temporary table would be more efficient. Then the rollback isn't necessary.
2013/12/11 Jov <zhao6...@gmail.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" <plakr...@gmail.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 >> >
