[postgis-users] field type "public.geometry"

[Sandro Santilli]

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