[postgis-users] Storing geometries in variables

[Imre Samu]

> Has anyone got experience in storing geometries in variables,
> so that these can be used in a program?

psql ( postgres client ! )  has an advanced feature:  variables
*"Variables are simply name/value pairs, where the value can be any string
of any length."*
so you have to use  the string format of the geometry
https://www.postgresql.org/docs/12/app-psql.html#APP-PSQL-VARIABLES
https://stackoverflow.com/questions/36959/how-do-you-use-script-variables-in-psql

Imre




Shaozhong SHI <shishaozhong at gmail.com> ezt írta (időpont: 2020. aug. 21.,
P, 14:54):

> Has anyone got experience in storing geometries in variables, so that
> these can be used in a program?
>
> Regards,
>
> Shao
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200821/61b5e81d/attachment.html>