Личный кабинет
Укажите e-mail, на который будет выслан код восстановления пароля.
На указанный вами адрес e-mail был выслан код подтверждения аккаунта. Введите полученный код для продолжения:
Введите новый пароль два раза:
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@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_EXPLAINAny suggestions are welcome.Best,Peter
you can use the transition. eg: begin; creat table(...); catch error if the statement not validated. rollback;
jov
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_EXPLAINAny suggestions are welcome.Best,Peter
В списке pgsql-general по дате отправления: