[postgis-users] addgeometrycolumn() does not exist

[Romi Hardiyanto]

Aaron Steele wrote:
> 
> <snippit>
> CREATE TABLE counties (gid serial, AREA float8, PERIMETER float8,  
> CNTY24K97# int4, CNTY24K97- int4, NAME varchar, NAME_CAP varchar, NUM  
> int4, FIPS_CODE int4);

You should rename the field "CNTY24K97#" (and maybe CNTY24K97-) in your 
cnty24k97.dbf file, before convert cnty24k97.shp again,
or
enclose the CNTY24K97# (and maybe CNTY24K97-) with double quotes in 
resulted sql file.

Romi Hardiyanto