On Thu, 3 Oct 2002, Shridhar Daithankar wrote:
> On 2 Oct 2002 at 18:01, Michelle Konzack wrote:
>
> > Hello,
> >
> > I have gotten a 16 MByte textfile with around 27.000 lines of data
> > which contains a database with 22 fields which are <TAB> seperated.
> >
> > How can I import it into a (new) table and or new
> > database of pgsql.
>
> You can use \copy in psql. I don't know how would you specify tab as delimeter.
> May be you should convert it to some other delimeter like ':' or ',' if tab
> does not work.
Tab is the separator for COPY. I'm not sure about \copy but I presume it's
going to be the same since it probably only does a copy in from stdin.
>
> Get a small chunk of that file. First 100 records or so and experiment.
> Otherwise it might get quite irritating..;-)
Very irritating.
--
Nigel J. Andrews