Postgres Pro
Downloads
Home   >   mailing lists

Overriding default psql behavior | how to ignore missing fields - Mailing list pgsql-general

From Håvard Wahl Kongsgård
Subject Overriding default psql behavior | how to ignore missing fields
Date
Msg-id AANLkTikhf2BG3QzkO7bkmuAfL=rRjGDOX3StxTLMRi87@mail.gmail.com
Whole thread Raw
In response to Overriding default psql behavior | how to ignore missing fields  (Håvard Wahl Kongsgård <haavard.kongsgaard@gmail.com>)
Responses Re: Overriding default psql behavior | how to ignore missing fields  (Adrian Klaver <adrian.klaver@gmail.com>)
List pgsql-general
Tree view
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 <vivek@khera.org> wrote:
2010/12/31 Håvard Wahl Kongsgård <haavard.kongsgaard@gmail.com>:
> 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.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



--
Håvard Wahl Kongsgård
Peace Research Institute Oslo (PRIO)



--
Håvard Wahl Kongsgård
Peace Research Institute Oslo (PRIO)

http://havard.security-review.net/

pgsql-general by date:

Previous
From: Vick Khera
Date:
Subject: Re: Overriding default psql behavior | how to ignore missing fields
Next
From: Gordon Shannon
Date:
Subject: Re: seg fault crashed the postmaster