0

I'm new to PostgreSQL.

For the default install of PostgreSQL (no extension like PostGIS), if there's geographic fields defined in my table, then what kinds of index does PostgreSQL support?

I didn't find any information on the spatial index in the manual.

Lenik
  • 13,946
  • 17
  • 75
  • 103

1 Answers1

2

Use GiST, just like PostGIS uses.

But why don't you install PostGIS in your database?

Frank Heikens
  • 117,544
  • 24
  • 142
  • 135