Re: [GENERAL] one problem

On Tue, 6 Jul 1999, Jonathan davis wrote:

>
> -----Message d'origine-----
> De : Jonathan davis <haj(at)idianet(dot)net>
> À : 'pgsql-general(at)postgreslq(dot)org' <pgsql-general(at)postgreSQL(dot)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.