Book a Demo

Author Topic: Extensible CREATE INDEX DDL  (Read 2432 times)

Simon Greener

  • EA Novice
  • *
  • Posts: 4
  • Karma: +0/-0
    • View Profile
Extensible CREATE INDEX DDL
« on: April 09, 2012, 02:11:47 pm »
Folks,
When indexing PostgreSQL/PostGIS geometry/geography type data one needs to add USING GIST(<<column_name>>) at the end as follows:

Assume I have a table called WELL with a geometry column called GEO:

CREATE INDEX well_geo_spdx
    ON public.well
 USING gist(geo);

How can I annotate an Entity in Enterprise Architect such that when I generate DDL for the well table I get index DDL as above?

regards
Simon