how to use geometry datatype to postgres table?

Question

I have setup a postgres database(version 9.1) and trying to create a table capable of storing st_geometry with the following query :

CREATE TABLE sensitive_areas (area_id integer, name varchar(128), zone st_geometry);

But I am getting the error as follows :

ERROR:  type "st_geometry" does not exist

Do I need to configure my postgres installation further to enable geometry data type .

Mike T · Accepted Answer · 2012-05-18 10:24:51Z

11

The correct type name is geometry. If you are you are using PostGIS 2.0 you can use a typmod:

-- If you haven't done so already
CREATE EXTENSION postgis;

-- Make a table of Polygons, using long/lat coords
CREATE TABLE sensitive_areas (
    area_id integer primary key,
    name varchar(128),
    zone geometry(Polygon,4326)
);

answered May 18, 2012 at 10:24

Mike T

44.4k18 gold badges166 silver badges213 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Quassnoi · Accepted Answer · 2012-05-18 10:12:57Z

4

CREATE TABLE sensitive_areas (area_id integer, name varchar(128), zone geometry);

You should have PostGIS installed in you db for this to work.

answered May 18, 2012 at 10:12

Quassnoi

428k94 gold badges628 silver badges624 bronze badges

Collectives™ on Stack Overflow

how to use geometry datatype to postgres table?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related