Toad World® Forums

Geography data type in postgresql

Hello,

Postgis is a famous extension for postgresql. It has a data type named geography. This is the documentation page:

http://workshops.boundlessgeo.com/postgis-intro/geography.html

…and this is an example of table creation:

  CREATE TABLE airports (
code VARCHAR(3),
geog **GEOGRAPHY(Point)**
);

How could you create this data type in Toad Data Modeler 6?

Hello,

Geography data type is not supported in Toad Data Modeler but there is a workaround how to obtain it.
You can create this data type as user data type by the following procedure:

  • go to the model explorer and create a new object User Data Type
  • rename it to GEOGRAPHY
  • set the Type as “Base”
  • specify default value of parameter as “Point”
  • uncheck the option Generate
    Now you can assign this type to attribute.

Thanks for your reply. Works fine.