Re: Export From Postresql to a DBF File Format

Bob,

Try pg2xbase and xbase2pg. Look it up on the net.

JLL

>
> MS Access can be used as a flexible tool for reshaping
> data. Using MS Access on the client-side, I am able
> to link to PostgreSQL tables via ODBC. Once
> connected, I export data into many data formats (text
> files, .dbf, Paradox, FoxPro, Excel, etc). If I need
> to change the format or values of the data itself, I
> do so in a query, and export the query results.
>
> You can use this same method with other ODBC compliant
> databases such as Paradox. (I would _not_ recommend
> Lotus Approach for this.)
>
> Best of luck,
>
> Andrew Gould
>
> --- Bob Powell <bob(at)hotchkiss(dot)org> wrote:
> > Hello Everyone:
> >
> > I've searched the FAQ's and found no references to
> > this. I would like to be able to create a standard
> > .DBF file format when exporting table data from
> > Postgresql. Does anyone know how to do this or have
> > a utility for it?
> >
> > Bob Powell
> > The Hotchiss School
> >
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Tax Center - online filing with TurboTax
> http://taxes.yahoo.com/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html