[postgis-users] shp2pgsql - how to avoid double quotes around table name and column names

cyw at dls.net cyw at dls.net
Thu Sep 4 15:37:33 PDT 2008


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080904/b109275d/attachment.html>


More information about the postgis-users mailing list