Re: Text Import

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(at)ebsllc(dot)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/