Hot answers tagged postgresql
The function returns a table with typed columns (a schema) and rows (values). The .* at the end means "all columns from the table." It's a bit like SELECT * FROM X, but acts as syntactic sugar so you don't have to wrap the function call in a (SELECT * FROM function()).
This is more of a PostgreSQL question rather than a PostGIS question, but sill a good one. Functions like ST_PixelAsPoints, ST_PixelAsPolygons, and ST_PixelAsCentroids return a set of composite record data type, which have several fields. This is very similar to ST_Dump, described here. To gain access to all the returned fields from these composite data ...
Only top voted, non community-wiki answers of a minimum length are eligible