Overriding default psql behavior | how to ignore missing fields

[Håvard Wahl Kongsgård <haavard.kongsgaard@xxxxxxxxx>]

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@xxxxxxxxx> wrote:

2010/12/31 Håvard Wahl Kongsgård <haavard.kongsgaard@xxxxxxxxx>:

> 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

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

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

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