How to read data from a postgresql SQL?

Asked

Viewed 60 times

-1

Hello, Good afternoon I am relatively new programming, I have been working on a project that involves the mapping of some equipment, I did my part without problems but now I need to insert data from another application that is kind of the project my father.

The current state is this:

1.I built my database with Mongodb, and the old project was done with Django using postgresql as the database.

2.I have the old application’s Sql File.

3.I got an important piece of data by reading the files and taking it in hand

The problem in question is this::

1.I cannot pick up or identify in the file something that has the latitude and longitude that is what I need

I wanted to know if someone has a way to read this file and visualize it in a more understandable way (What I took was in the same code )

I tried to care but I couldn’t, I’m pretty layabout messing with this part.

sql postgresql mongodb migration

  • Postgis is not a database, it is a spatial extension developed over the Postgresql database management system, which allows the storage and use of GIS objects in databases. See: https://postgis.net/

  • This would be https://postgis.net/workshops/postgis-intro/loading_data.html ?

  • A thousand apologies, friend, I really made a mistake

  • This link teaches how to make the connection, there is some way to only observe the sql data that I have ?

  • It is impossible to "observe" the data of a database without making a connection (I understand "observe" as "read").

1 answer

0


Guys thanks more my problem was different,

I didn’t solve it by conventional method but I found the coordinates, they were like Geometry so I wondered,

I took what I needed using the same code.

Thank you

Browser other questions tagged sql postgresql mongodb migration

You are not signed in. Login or sign up in order to post.