SQL Alchemy - How to use built-in function in PostgreSQL database?

Question

I want put this query into code:

select * from st_geomfromtext('POINT(106.69588536141288 10.782847409207672)')

Here is what I did in code:

class st_geomfromtext(GenericFunction):
    name = 'st_geomfromtext'

query = Session.query(func.st_geomfromtext('POINT(106.69588536141288 10.782847409207672)')).all()

Here is what I receive:

LINE 1: SELECT st_geomfromtext('POINT(106.69588536141288 10.78284740...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

Ilya Berdichevsky · Accepted Answer · 2021-01-06 04:46:04Z

2

Are you able to validate your query directly against PostgreSQL?

Function may actually not be there. st_geomfromtext is part of PostGIS, depending on the PostgreSQL version, you may need to install / enable it.

answered Jan 6, 2021 at 4:46

Ilya Berdichevsky

1,29810 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL Alchemy - How to use built-in function in PostgreSQL database?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related