Re: REGARDING ADDING A DATATYPE LIKE POLYGON - Mailing list pgsql-novice

From Willy-Bas Loos
Subject Re: REGARDING ADDING A DATATYPE LIKE POLYGON
Date
Msg-id CAHnozTjX7aTikf+AOaQTG7FySgLYGFcW9_cFSgc39igWS0yQFg@mail.gmail.com
Whole thread Raw
In response to REGARDING ADDING A DATATYPE LIKE POLYGON  (Bibek Behera <bibek.iitkgp@gmail.com>)
List pgsql-novice
you could use postgis. it has a geometry datatype. you can define it to be a polygon.
like so:
create table test(id serial primary key);
select addgeometrycolumn('public', 'test', 'the_geom', 4326, 'POLYGON', 2);

hth

WBL

On Thu, May 3, 2012 at 1:04 PM, Bibek Behera <bibek.iitkgp@gmail.com> wrote:
Where in the postgres source code should we make changes to run a sql query like
create table test(a polygon2)

--
Regards,
Bibek behera
IIT Bombay


Ph no.- 8879005749




--
"Quality comes from focus and clarity of purpose" -- Mark Shuttleworth

pgsql-novice by date:

Previous
From: Bibek Behera
Date:
Subject: REGARDING ADDING A DATATYPE LIKE POLYGON
Next
From: Merlin Moncure
Date:
Subject: Re: REGARDING ADDING A DATATYPE LIKE POLYGON