# Error : No method asJSON S3 class: pq\_geometry is raised when try to import data from PostgreSQL

**URL:** <https://community.exploratory.io/t/error-no-method-asjson-s3-class-pq-geometry-is-raised-when-try-to-import-data-from-postgresql/2102>\
**Category:** Issues\
**Created:** [October 28, 2021, 3:41am UTC](https://community.exploratory.io/t/error-no-method-asjson-s3-class-pq-geometry-is-raised-when-try-to-import-data-from-postgresql/2102 "2021-10-28T03:41:00Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Hide\_Kojima1](https://community.exploratory.io/user_avatar/community.exploratory.io/hide_kojima1/32/398_2.png) [@Hide\_Kojima1](https://community.exploratory.io/u/Hide_Kojima1)\
**Post date:** [October 28, 2021, 3:41am UTC](https://community.exploratory.io/t/error-no-method-asjson-s3-class-pq-geometry-is-raised-when-try-to-import-data-from-postgresql/2102/1 "2021-10-28T03:41:00Z")

</div>

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.

```r
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](https://postgis.net/docs/ST_AsText.html)
