Overriding default psql behavior | how to ignore missing fields

Поиск
Список
Период
Сортировка
От Håvard Wahl Kongsgård
Тема Overriding default psql behavior | how to ignore missing fields
Дата
Msg-id AANLkTikhf2BG3QzkO7bkmuAfL=rRjGDOX3StxTLMRi87@mail.gmail.com
обсуждение исходный текст
Ответ на Overriding default psql behavior | how to ignore missing fields  (Håvard Wahl Kongsgård <haavard.kongsgaard@gmail.com>)
Ответы Re: Overriding default psql behavior | how to ignore missing fields  (Adrian Klaver <adrian.klaver@gmail.com>)
Список pgsql-general
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Vick Khera
Дата:
Сообщение: Re: Overriding default psql behavior | how to ignore missing fields
Следующее
От: Gordon Shannon
Дата:
Сообщение: Re: seg fault crashed the postmaster