Re: ST_AsMVTGeom AND table name as parameter in pl/psql

2020-09-16 Thread Tom Lane
James McManus writes: > However, when I try and use EXECUTE in the mvtgeom AS section of the script > I get a syntax error on EXECUTE: You need to convert the *entire* query into a string and apply EXECUTE to that. You can't use EXECUTE as a part of a query. regards, tom

ST_AsMVTGeom AND table name as parameter in pl/psql

2020-09-16 Thread James McManus
I'm trying to develop a plpgsql function that would extract mapbox vector tiles from a postgresql/post gis database. The database has multiple geospatial tables, so I want the function to be able to take a table name as a parameter. I've gotten the function to work using hard coded table names. Di