Обсуждение: 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
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 > > 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