Error : No method asJSON S3 class: pq_geometry is raised when try to import data from PostgreSQL

Issues
#1

When you try to import data from PostgreSQL instance, you might get the below error if your SQL query contains columns whose data type is geometry which is not supported in Exploratory.

Error : No method asJSON S3 class: pq_geometry

If this is the case, you might want to update your SQL query to convert/cast the data type to something more common such as text.

ref: https://postgis.net/docs/ST_AsText.html

2 Likes