createSpatialIndex method

Future<void> createSpatialIndex(
  1. TableName tableName,
  2. String geometryName
)

Create a spatial index

@param e feature entry to create spatial index for

Implementation

Future<void> createSpatialIndex(
    TableName tableName, String geometryName) async {
  String sql = "CREATE INDEX " +
      tableName.name +
      "__" +
      geometryName +
      "_spx ON " +
      tableName.name +
      " USING GIST (" +
      geometryName +
      ");";

  await _postgresDb.execute(sql);
}