Re: Import textfile as table

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