当程序中向postgresql或postgis中插入或者更新数据时,出现如下的错误:
org.postgresql.util.PSQLException: ERROR: zero-length delimited identifier at or near """"
...
解决办法:在Postgres查询时,对于String你只能用单引号或者&来标识。In a Postgres query, you should always use single quotes or "dollar quotes" (see http://www.postgresql.org/docs/8.1/interactive/sql-syntax.html#SQL-SYNTAX-DOLLAR-QUOTING) for string literals.