Export From Postresql to a DBF File Format
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
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/
Bob,
Try pg2xbase and xbase2pg. Look it up on the net.
JLL
Show quoted text
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?