On Tue, 6 Jul 1999, Jonathan davis wrote:
>
> -----Message d'origine-----
> De : Jonathan davis <haj@idianet.net>
> À : 'pgsql-general@postgreslq.org' <pgsql-general@postgreSQL.org>
> Date : mardi 6 juillet 1999 12:45
> Objet : [GENERAL] one problem
>
>
> >Hello all
> >
> >how to get back one database (text format) to postgresql ?
> >
> >field1 field2 field3 ...
> >field1 field2 field3 ...
> >.
> >.
> >.
> >
> >thanks
> >
>
>
> the COPY command does that BUT BUT BUT BUT !!!
> how to specify the fields for example I just insert field2 into the
> database
>
> example:
>
> create table country (code char(2), country char(20));
>
> and i want to insert just the field country not the field code
>
> how to proceed ?
>
Some bash or perl magic to preprocess that file could help. I hear the
cut(1) command does wonders.
--
Peter Eisentraut
PathWay Computing, Inc.