Re: Changing the Primary Key Column

On Wed, 23 Feb 2011, Tim Bruce wrote:

> Why not just dump the data (dump just the table with pg_dump), drop the
> table, build the new table and re-load the data (using psql)?

Tim,

I've not done this before and I'd still need to manually drop the first
column's worth of data.

Since I've been using the copy command, I will think overnight of copying
the table to a .csv file, editing that in emacs or joe (to remove the first
column), then drop the original table and copy it back in.

Then I'll need to figure out postGIS so I can map locations and build
surface maps.

Thanks,

Rich