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 >
