Editing field

[lrigell]

I was attempting to perform the Spatial Join in QGIS with post-gis. I wanted to select the crime date so that I could have the date of each crime appear in my output table. However, post GIS did not recognize the "Dispatch Date" field in the crime data, since it has a space in the title. I attempted to edit the field name by turning on toggle editing in QGIS, but my QGIS keeps freezing.

How have others dealt with this issue?

[galkamax]

@lrigell if you enclose the field name in double quotes ("dispatch date") PostGIS should be able to recognize it