131 HeapTupleData tmptup,
134 bool needsep =
false;
136 StringInfo props = makeStringInfo();
137 bool geom_column_found =
false;
139 sep = use_line_feeds ?
",\n " :
", ";
141 td = DatumGetHeapTupleHeader(composite);
144 tupType = HeapTupleHeaderGetTypeId(td);
145 tupTypmod = HeapTupleHeaderGetTypMod(td);
146 tupdesc = lookup_rowtype_tupdesc(tupType, tupTypmod);
149 tmptup.t_len = HeapTupleHeaderGetDatumLength(td);
153 appendStringInfoString(
result,
"{\"type\": \"Feature\", \"geometry\": ");
155 for (i = 0; i < tupdesc->natts; i++)
162 Form_pg_attribute att = TupleDescAttr(tupdesc, i);
163 bool is_geom_column =
false;
165 if (att->attisdropped)
168 attname = NameStr(att->attname);
170 if (geom_column_name)
171 is_geom_column = (strcmp(attname, geom_column_name) == 0);
173 is_geom_column = (att->atttypid == geom_oid || att->atttypid == geog_oid);
175 if ((!geom_column_found) && is_geom_column)
178 geom_column_found =
true;
180 val = heap_getattr(tuple, i + 1, tupdesc, &isnull);
190 Int32GetDatum(maxdecimaldigits))));
194 appendStringInfoString(
result,
"{\"type\": null}");
200 appendStringInfoString(props, sep);
203 escape_json(props, attname);
204 appendStringInfoString(props,
": ");
206 val = heap_getattr(tuple, i + 1, tupdesc, &isnull);
211 outfuncoid = InvalidOid;
216 datum_to_json(val, isnull, props, tcategory, outfuncoid,
false);
220 if (!geom_column_found)
222 (errcode(ERRCODE_INVALID_PARAMETER_VALUE),
223 errmsg(
"geometry column is missing")));
225 appendStringInfoString(
result,
", \"properties\": {");
226 appendStringInfo(
result,
"%s", props->data);
228 appendStringInfoString(
result,
"}}");
229 ReleaseTupleDesc(tupdesc);
char result[OUT_DOUBLE_BUFFER_SIZE]
static void json_categorize_type(Oid typoid, JsonTypeCategory *tcategory, Oid *outfuncoid)
Datum LWGEOM_asGeoJson(PG_FUNCTION_ARGS)
static void datum_to_json(Datum val, bool is_null, StringInfo result, JsonTypeCategory tcategory, Oid outfuncoid, bool key_scalar)