getGeometryColumnNameAndSridForTable method

Future<List?> getGeometryColumnNameAndSridForTable(
  1. TableName tableName
)

Implementation

Future<List<dynamic>?> getGeometryColumnNameAndSridForTable(
    TableName tableName) async {
  String sql = "select " +
      PostgisGeometryColumns.F_GEOMETRY_COLUMN +
      ", " //
      +
      PostgisGeometryColumns.SRID +
      " from " //
      +
      PostgisGeometryColumns.TABLENAME +
      " where Lower(" +
      PostgisGeometryColumns.F_TABLE_NAME +
      ")=Lower(?)";

  var queryResult = await _postgresDb.select(sql, [tableName.name]);
  if (queryResult != null && queryResult.length == 1) {
    var row = queryResult.first;
    return [row.getAt(0), row.getAt(1)];
  }
  return null;
}