Problem with a column name contains a colon in PostgreSQL

Question

I downloaded the shape data from OSM. I have imported data from Shapefile into PostgreSQL without any problem but I got an error when I do the select statement.

Select addr:city From location;

Error: syntax error at or near ":"

The problem is because of the column name contains a colon. Could anyone help me with this issue? Should I reject this shapefile in the importing process? Is the shapefile normal?

@Nick : This would select the string 'addr:city', not the column. You want to use double quote in this case. — Vincent Savard
– Vincent Savard, Commented Feb 9, 2011 at 4:06

Wouter van Nifterick · Accepted Answer · 2011-02-09 03:26:44Z

15

If you enclose addr:city with quotes it should work:

SELECT "addr:city" FROM "location";

And if you want to use OpenStreetMap data, you don't have to import shapefiles. Instead, you can import planet.osm (or a regional subset) directly with osm2pgsql.

edited Feb 9, 2011 at 3:26

answered Feb 9, 2011 at 3:19

Wouter van Nifterick

24.2k7 gold badges82 silver badges123 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Problem with a column name contains a colon in PostgreSQL

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related