Thread: Text Import

Text Import

From
Pete Poggione
Date:
Does anyone know where I can find some good documentation on importing a
fixed record length text file into a postgresql table? I find lots of
information for importing delimited files.

Thanks,
Pete




Re: Text Import

From
Jason Earl
Date:
You are probably going to have to script the import (I
like Python for this, but Perl is probably the most
popular tool for this type of thing).

You might try importing your data into Gnumeric (or
Excel I suppose), and then exporting it as a delimited
file, if your data file isn't too terribly big (less
than 65K lines).

If you need some help cooking something up I would be
happy to give you a hand.

Jason


--- Pete Poggione <ppoggione@ebsllc.com> wrote:
> Does anyone know where I can find some good
> documentation on importing a
> fixed record length text file into a postgresql
> table? I find lots of
> information for importing delimited files.
>
> Thanks,
> Pete
>
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster


__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/