Postgis GEOGRAPHY(POINT) type #780
Unanswered
sergiohdljr
asked this question in
Q&A
Replies: 1 comment
-
I know this is late but refer to #503 (comment) |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
I have a table with a column of the type GEOGRAPHY(POINT)
this is how is made a insert in the pgadmin work just fine
sql
INSERT INTO farmacia (nome, telefone, cidade, bairro, rua, numero, coords) VALUES ('Farmacia Espinheio', '40023633', 'Recife', 'Espinheiro', 'Rua do Espinheiro', 222 , ST_GeographyFromText('POINT(-34.89536080032862 -8.04613923401633)'));
but for some reason when i try to insert with postgres.js library, like that :
![Captura de tela de 2024-01-17 15-05-21](https://private-user-images.githubusercontent.com/102623806/297475481-fc5f3864-2a96-4e28-9a56-761b15aa595c.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjExMzEyMTUsIm5iZiI6MTcyMTEzMDkxNSwicGF0aCI6Ii8xMDI2MjM4MDYvMjk3NDc1NDgxLWZjNWYzODY0LTJhOTYtNGUyOC05YTU2LTc2MWIxNWFhNTk1Yy5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwNzE2JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDcxNlQxMTU1MTVaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT1iYjUyZGZlY2Y0ZjJkMGNjMTAyNWY0YzVmZjJjZGM2NDVhNzJkNDAwMmNkYjZhNzk4NGI0YzIwNTBjYTZhNzE4JlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.cHzTzxzVRpH_TznRvcIUHkWIDW8DGHa1GL5w5QS9uNQ)
i get the follow error :
![Captura de tela de 2024-01-17 15-06-17](https://private-user-images.githubusercontent.com/102623806/297475649-66ce69c2-8462-487e-a5fd-7e8857078c1e.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjExMzEyMTUsIm5iZiI6MTcyMTEzMDkxNSwicGF0aCI6Ii8xMDI2MjM4MDYvMjk3NDc1NjQ5LTY2Y2U2OWMyLTg0NjItNDg3ZS1hNWZkLTdlODg1NzA3OGMxZS5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwNzE2JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDcxNlQxMTU1MTVaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT1lOTUyZjkwNzM1YjA2MGM4N2RkZDgwNmNmMmEwZTBjZTY5MzMxOTMwN2I4MTY2YjBjM2QzMzkyODkyNjk1NWVmJlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.egOX4WVSotPv-r-pN5uaJHcf82LVCKw7jfsuXccmXDM)
I am very open to suggestions.
Beta Was this translation helpful? Give feedback.
All reactions