Postgres 13

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.

CREATE TEMPORARY TABLE tmp (geom GEOMETRY);
INSERT INTO tmp VALUES ('SRID=4326;POINT (1 2)'),
                       ('SRID=4326;POINT (2 4)');

CREATE TABLE

INSERT 0 2

SELECT geom FROM tmp;

geom

0101000020E6100000000000000000F03F0000000000000040

0101000020E610000000000000000000400000000000001040

SELECT 2

SELECT ST_AsText(geom),ST_AsEWKT(geom) FROM tmp;

st_astext
st_asewkt

POINT(1 2)
SRID=4326;POINT(1 2)

POINT(2 4)
SRID=4326;POINT(2 4)

SELECT 2

SELECT ST_AsGeoJSON(geom) FROM tmp;

st_asgeojson

{"type":"Point","coordinates":[1,2]}

{"type":"Point","coordinates":[2,4]}

SELECT 2

SELECT ST_AsGML(geom) FROM tmp;

st_asgml

<gml:Point srsName="EPSG:4326"><gml:coordinates>1,2</gml:coordinates></gml:Point>

<gml:Point srsName="EPSG:4326"><gml:coordinates>2,4</gml:coordinates></gml:Point>

SELECT 2

SELECT ST_AsKML(geom) FROM tmp;

st_askml

<Point><coordinates>1,2</coordinates></Point>

<Point><coordinates>2,4</coordinates></Point>

SELECT 2

st_astext	st_asewkt
POINT(1 2)	SRID=4326;POINT(1 2)
POINT(2 4)	SRID=4326;POINT(2 4)