On Friday 31 December 2010 9:06:19 am Håvard Wahl Kongsgård wrote:
> Well I created the SQL files from multiple shapefiles. Used the shp2sql (
> postgis 1.5) to generate the SQL dumps.
>
And the shp2pgsql docs say:
"Appends data from the Shape file into the database table. Note that to use
this
On 2010-12-31, Håvard Wahl Kongsgård wrote:
> --90e6ba488359a7721f0498b43825
> Content-Type: text/plain; charset=ISO-8859-1
> Content-Transfer-Encoding: quoted-printable
>
> Hi,
> I am trying to insert new records from multiple SQL dumps into an existing
> table. My problem is that the database ta
Well I created the SQL files from multiple shapefiles. Used the shp2sql (
postgis 1.5) to generate the SQL dumps.
On Fri, Dec 31, 2010 at 5:00 PM, Vick Khera wrote:
> 2010/12/31 Håvard Wahl Kongsgård :
> > Is it possible to overriding the default psql behavior, so that the sql
> > session simpl
2010/12/31 Håvard Wahl Kongsgård :
> Is it possible to overriding the default psql behavior, so that the sql
> session simply ignores any missing fields?
>
Do you still have the original database? Re-run your table exports
without the unneeded columns using COPY, then import those outputs
instead
Hi,
I am trying to insert new records from multiple SQL dumps into an existing
table. My problem is that the database table does not have some of the
columns used in the sql dumps. So when I try to import the dumps psql fails
with: "ERROR: current transaction is aborted, commands ignored until end
