Opened 15 years ago

Last modified 7 years ago

#123 closed task

SQLite output format support for shp2pgsql — at Initial Version

Reported by: schuyler.erle Owned by:
Priority: medium Milestone: PostGIS Fund Me
Component: postgis Version:
Keywords: Cc:

Description

Please find attached a patch that adds a -L option to shp2pgsql provide special-case data typing and string formatting for SQLite-compatible output.

I have tested the output with SQLite 3.5.2 and it correctly creates and populates a table. The geometries are correctly stored as WKB in an SQLite BLOB column.

Granted there are other ways to import spatial data into an SQLite table, but shp2pgsql is the fastest way that I've found to convert both Shapefiles *and* DBF files into SQL suitable for quick import into a database, which is very handy for piping to SQLite's in-memory databases.

Change History (0)

Note: See TracTickets for help on using tickets.