[postgis-users] get transformation matrix for st_affine using before and after polygons

[Rhys A.D. Stewart]

Greetings folks,

Lets say I have two polygons, A and B. These polygons are identical
(I.E. st_astext(A) = st_astext(B) is true, vertex for vertex clones).
If I were to move (both translate and rotate)  B somewhere else (using
QGIS for example) is it possible to generate the transformation
matrixthat could be used in st_affine to accomplish the same using
postgis?


Regards,

Rhys
Peace & Love|Live Long & Prosper