title: Combine 2 columns in 1, PostgreSQL
body: <p>I have two columns column1, column2 that are curently type of real and I want to combine them in order to get a geometry(Point,4326).
  My current code is this one:</p>
  
  <pre><code>INSERT INTO table2(location)
  SELECT
      geometry(POINT(column1, column2))
  FROM
      table1
  </code></pre>
  
  <p>I get this error: <code>Geometry SRID (0) does not match column SRID (4326)</code></p>
  
  <p>When I try to add the SRID in my geometry: <code>geometry(POINT(column1, column2),4326)</code> it doesnt recognize geometry, throwing error: <code>function geometry(point, integer) does not exist</code></p>
  
  <p>Note that location is type of <code>geometry(POINT, 4326)</code> . I have also tried UpdateGeometrySRID: <code>select UpdateGeometrySRID('public', 'table2', 'location', 4326) ;</code> but i still get the same errors in both cases.</p>
  
  <p>Any ideas?</p>