Hi All,

The shp2pgsql generated sql uses double quotes around table name and column 
names, such as:

    CREATE TABLE "x" (gid serial PRIMARY KEY, "route" varchar, "jurisdicti" 
varchar,....

The effect is that I have to use double quotes in SQLs that access data  in 
this table later on. For example, I have to use sql like:

    select * from "x" 

Sql without double quotes, such as below, won't work:
    select * from x

Thanks for any help.

cyw
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply via email to