Re: REGARDING ADDING A DATATYPE LIKE POLYGON

From: Willy-Bas Loos <willybas(at)gmail(dot)com>
To: Bibek Behera <bibek(dot)iitkgp(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: REGARDING ADDING A DATATYPE LIKE POLYGON
Date: 2012-05-03 12:54:39
Message-ID: CAHnozTjX7aTikf+AOaQTG7FySgLYGFcW9_cFSgc39igWS0yQFg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)iitkgp(at)gmail(dot)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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Merlin Moncure 2012-05-03 13:22:41 Re: REGARDING ADDING A DATATYPE LIKE POLYGON
Previous Message Bibek Behera 2012-05-03 11:04:33 REGARDING ADDING A DATATYPE LIKE POLYGON