title: Postgis longitude, latitude to geometry postgresql
body: <p>I'm migrating all information in a PostGIS system, with full information about thousands of sport spaces. For all this spaces I got latitude and longitude values, and PostGis need a geometry value for that, this column is already in my table "Location".</p>
  
  <p>The SRID of that application is 23030.</p>
  
  <p>I've looked for how to calculate a geometry value from longitude and latitude, and I find that:</p>
  
  <pre><code>update location set point=ST_GeomFromText('POINT('|| longitud || ' ' || latitud ||')',23030);
  UPDATE georrepositorio.geometria SET point = ST_SetSRID(ST_Point( longitud, latitud),23030);
  UPDATE georrepositorio.geometria SET POINT = ST_SetSRID(ST_MakePoint(longitud,latitud),23030);
  </code></pre>
  
  <p>I always get a string like: <code>"0101000020F6590000894327550B97114104EA99EA599D4E41"</code></p>
  
  <p>In the web application which I am building, if I mark the point to locate the space, it insert in table "location" a string like: <code>"0101000020F659000000000020DFB115C00000008053244240"</code> which looks similar to the string I got using those functions.</p>
  
  <p>The problem is that i can't locate each space because there are so many, so I need a massive migration, and using those function to calculate geometry columns doesn't work. Because ok, those functions calculate a geom value, but when you query the application doesn´t show them.</p>
  
  <p>Anyone knows how to calculate geomtry from latitude and longitude, please? anything</p>