Postgres Pro
Downloads
Home   >   mailing lists

Thread: Export From Postresql to a DBF File Format

Export From Postresql to a DBF File Format

From
"Bob Powell"
Date:
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

Re: Export From Postresql to a DBF File Format

From
Andrew Gould
Date:
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@hotchkiss.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/

Re: Export From Postresql to a DBF File Format

From
Jean-Luc Lachance
Date:
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@hotchkiss.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