manually install postgis 2.0.x on windows 7

when doing installation postgis on windows 7 manually, You may encounter a problem when?

?

"create extension postgis" is operated.?

?

pg may complain some errors about insecure usage of backslash quote in client programming?

?

a simple solution is :

?

find out postgis-2.0.x on your_postgis_path/share/extensions/

?

remove all \'.

?

\' in my case only appear in this block:

?

IF format != 'GDAL' THEN

? ? ? ? ? ? ? ? RAISE WARNING E'Format \'%\' is not recognized, defaulting to GDAL format.', format;

? ? ? ? ? ? END IF;

?

?

running "create extension postgis" again, it should work now.