<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Thanks to Ben Madin for advice. I removed the apostrophes from the SRID in nyc_buildings.sql (using TextEdit) and re-ran the command<div><br></div><div><div><font class="Apple-style-span" color="#2148f5">/usr/local/pgsql-9.0/bin/psql -f /Users/bacmac/nyc_buildings.sql nyc</font></div></div><div><br></div><div>Unfortunately it produced the same result:</div><div><br></div><div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "><font class="Apple-style-span" color="#2148f5">BEGIN</font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "><font class="Apple-style-span" color="#2148f5">psql:/Users/bacmac/nyc_buildings.sql:3: NOTICE: CREATE TABLE will create implicit sequence "nyc_buildings_gid_seq" for serial column "nyc_buildings.gid"</font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "><font class="Apple-style-span" color="#2148f5">psql:/Users/bacmac/nyc_buildings.sql:3: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "nyc_buildings_pkey" for table "nyc_buildings"</font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "><font class="Apple-style-span" color="#2148f5">CREATE TABLE</font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "><font class="Apple-style-span" color="#2148f5">psql:/Users/bacmac/nyc_buildings.sql:4: ERROR: function addgeometrycolumn(unknown, unknown, unknown, integer, unknown, integer) does not exist</font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "><font class="Apple-style-span" color="#2148f5">LINE 1: SELECT AddGeometryColumn('','nyc_buildings','the_geom',2908,...</font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "><font class="Apple-style-span" color="#2148f5"> ^</font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "><font class="Apple-style-span" color="#2148f5">HINT: No function matches the given name and argument types. You might need to add explicit type casts.</font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "><font class="Apple-style-span" color="#2148f5">psql:/Users/bacmac/nyc_buildings.sql:5: ERROR: current transaction is aborted, commands ignored until end of transaction block</font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "><font class="Apple-style-span" color="#2148f5">psql:/Users/bacmac/nyc_buildings.sql:6: ERROR: current transaction is aborted … and so on.</font></div></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "><font class="Apple-style-span" color="#2148f5"><br></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "><font class="Apple-style-span" color="#000003">I wonder if I need to adjust $PATH so that the function AddGeometryColumn is found? Even when I change directory to </font><font class="Apple-style-span" color="#1a3bd0">/usr/local/pgsql-9.0/bin</font><font class="Apple-style-span" color="#000003"> my Mac cannot find </font><font class="Apple-style-span" color="#1a3bd0">psql</font><font class="Apple-style-span" color="#000003"> if I type that command on its own. I always have to use the full pathname</font><font class="Apple-style-span" color="#1a3bd0"> /usr/local/pgsql-9.0/bin/psql</font><span class="Apple-style-span" style="color: rgb(0, 0, 3); ">. Strange, because typing 'ls' after changing the directory brings up the complete list of files including </span><font class="Apple-style-span" color="#1a3bd0">psql</font><span class="Apple-style-span" style="color: rgb(0, 0, 3); ">.</span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "><font class="Apple-style-span" color="#000003"><br></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "><span class="Apple-style-span" style="color: rgb(0, 0, 3); ">Bruce Callander</span></div><div><br></div></body></html>