Opened 9 years ago

Last modified 7 years ago

#3033 new enhancement

FID column name option

Reported by: mohayemin Owned by: robe
Priority: medium Milestone: PostGIS Fund Me
Component: utils/loader-dumper Version: 2.1.x
Keywords: Cc:

Description

I want an option by which I can specify name of the FID column while importing a shapefile to PostGIS using shp2pgsql tool.

Currently there is no way to specify a name for FID column name. The name is set to gid. If another column has this name, that column is renamed to __gid.

A related question was posted in gis.stackexchange.

Change History (7)

comment:1 by robe, 9 years ago

Component: postgisloader/dumper
Milestone: PostGIS 2.2.0
Owner: changed from pramsey to robe

comment:2 by robe, 9 years ago

Milestone: PostGIS 2.2.0PostGIS 2.3.0

comment:3 by pnorman, 8 years ago

For what I'm working on I'd like to completely drop the gid column - in fact, drop all columns but the geometry.

comment:4 by robe, 8 years ago

Paul are you planning on working on this in the next week or 2. If not I'm going to push this to future to get out of 2.3 slate.

comment:5 by pnorman, 8 years ago

No, I have no eta on working on this.

For the project I'm doing I have to move to ogr2ogr since I need to handle more than just shapefiles.

comment:6 by robe, 8 years ago

Milestone: PostGIS 2.3.0PostGIS 2.4.0

comment:7 by robe, 7 years ago

Milestone: PostGIS 2.4.0PostGIS Fund Me
Note: See TracTickets for help on using tickets.