Latitude      | Longitude
+-----------------------------+

35.0528620000 | -119.375136000
+-------------|---------------+

[Err] ERROR:  syntax error at or near "ALTER"
LINE 1: EXPLAIN ALTER TABLE "allwells_CA_copy"

ERROR: syntax error at or near "ALTER" LINE 1: ..., VERBOSE off, COSTS on, BUFFERS off, TIMING off )ALTER TABL... ^ ********** Error ********** ERROR: syntax error at or near "ALTER" SQL state: 42601 Character: 71

ALTER TABLE mytable
  ALTER COLUMN "Longitude" TYPE NUMERIC(14, 11)
    USING ("Longditude"::NUMERIC(14,11)),
  ALTER COLUMN "Latitude" TYPE NUMERIC(14, 11)
    USING ("Latitude"::NUMERIC(14,11));

CREATE EXTENSION postgis;
BEGIN;
  ALTER TABLE foo ADD COLUMN geog geography;
  UPDATE foo SET geog = ST_MakePoint(long, lat);
  CREATE INDEX on foo USING gist ( geog );
  ALTER TABLE foo DROP COLUMN long, DROP COLUMN lat;
COMMIT;