[postgis-users] Help updating SRID values...

[David Blasby]

Bill Wheaton wrote:

> PostGISers:
>
> I have to change (update) the SRID in a geometry column. I've searched 
> for methods of doing this and came across some posts from about a year 
> ago...The procedure suggested by John Reid and Dave Blasby below seems 
> to work EXCEPT for the last step...SELECT INTO only seems to allow you 
> to create a NEW table not move records from one table to another. This 
> is probably a simple postgreSQL question, but I'm a stumped newbie. 
> The procedure I'm trying to follow is below. Again, I'm just trying to 
> update the SRID for a geometry column (had a dumb typo when loading 
> the data). If there is an easier way, I'd love to hear about it.

...

>
> 7. use "select into..." to put the rows in tmp_table into the new table

this command should look like:

   SELECT INTO  <original table> SELECT * FROM <temp table>;

If this doesnt work, what error are you getting?

dave