[postgis-users] PostgreSQL geometric data types vs GEOMETRY data type

[Baris Ergun]

Hi Peter;

Can u share ur CREATE Table sqls for both  tables u are testing against to
be more specific.


On 2 January 2014 21:10, Peter Len <peteralen at earthlink.net> wrote:

> I am using PostgreSQL 9.1 with PostGIS.  I am still doing a lot of
> documentation reading but have the following question....  PostgreSQL comes
> with some default geometric datatypes like POINT and POLYGON.  I created a
> couple of tables with these types and added some data.  After installing
> PostGIS, I came to find an example of creating a table with a GEOMETRY
> column.  It then went on to show the use of the PostGIS ST_GeomFromText
> method.  That worked fine on my test table that I created with the
> GEOMETRY(Point) data type but did not work on the table with just the POINT
> data type.  So.....  to use the PostGIS methods/functions, do the spatial
> columns need to be defined as GEOMETRY / GEOGRAPHY rather than the
> PostgreSQL data types of POINT, POLYGON, etc?
>
> Thanks - Peter
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>



-- 
Barış
www.linkedin.com/in/barisergun
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140102/a332c286/attachment.html>