[postgis-users] using quotation for table columns

CYW cyw at dls.net
Fri Jun 2 07:23:56 PDT 2006


Hi all,

For some tables I created with shp2pgsql, I have to use double quotations
around all non-geom table columns in SQL, e.g.,
	SELECT "ID" FROM sometable;

If I do: 
	SELECT ID FROM sometable;
It will say: column "id" does not exist.

Thanks,
_cyw_





More information about the postgis-users mailing list