getGeometryColumnNameAndSridForTable method
Future<List?>
getGeometryColumnNameAndSridForTable(
- 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;
}