[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] field type "public.geometry"
From:       Sandro Santilli <strk () keybit ! net>
Date:       2012-09-21 7:26:00
Message-ID: 20120921072600.GD5075 () gnash
[Download RAW message or body]

On Thu, Sep 20, 2012 at 06:51:02PM -0700, Phil Hurvitz wrote:
> So what I think I want to do is install the updated types from the
> postgis extension to the public schema, and then drop those types
> from the gis schema. Looks like a real mess since I can't seem to
> cast geometries in one schema to geometries in another schema.

Have you tried something like this ?

 ALTER TABLE tab ALTER COLUMN col TYPE public::geometry
   USING public::geometry(col::text);

--strk; 

 http://www.cartodb.com - Map, analyze and build applications with your data

                                       ~~ http://strk.keybit.net 

_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]