[postgis] PostgreSql point to Postgis point conversion

[Paul Ramsey]

Tony is right, if you want to do it inside the db, you'll have to script
up a converter in one of the internal languages. If this is just a
one-shot deal conversion, it is probably far simpler to dump the table
to text, run a perl process on it to modify the geometry entries, and
then upload the table again.

"TONY J.Y." wrote:
> 
> Yes. I think you can use any of the programming language
> to UPDATE each line, such as C, java, or PLpgSQL.
> 
> ----- Original Message -----
> From: <mj_vermeij at yahoo.com>
> To: <postgis at yahoogroups.com>
> Sent: Friday, November 16, 2001 5:43 AM
> Subject: [postgis] PostgreSql point to Postgis point conversion
> 
> > I have a database which contains some point fields. I would like to
> > convert these fields to PostGis point fields so that they can be
> > indexed. I can create the PostGis fields but would like to fill them
> > with the data from the PostgreSql fields, if possible via an UPDATE
> > or similar command. Is this possible?
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> > postgis-unsubscribe at yahoogroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
> >
> >
> >
> 
> 
> To unsubscribe from this group, send an email to:
> postgis-unsubscribe at yahoogroups.com
> 
> 
> 
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

-- 
      __
     /
     | Paul Ramsey
     | Refractions Research
     | Email: pramsey at refractions.net
     | Phone: (250) 885-0632
     \_

To unsubscribe from this group, send an email to:
postgis-unsubscribe at yahoogroups.com

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/