>
> > if you have jdbc drivers for both of them,
> > then just select from the postgres using a jdbc driver for postgre,
> > and manipulate the code within java to change datatype if necessary
> > and then simply insert the code into a foxpro table using a foxpro
> jdbc-odbc
> > bridge or a regular jdbc foxpro driver (if available)or something.
>
I don't want to use ODBC.
I want to use only JDBC.
I know the structure of the table in postgres and fox.
for the moment solution:
1)select from postgres table (using jdbc)
2)the interogation results in text format (using comma delimiters) are
importing in a fox table using foxpro program
use table_name
APPEND FROM salb.txt DELIMITED WITH CHARACTER |
But I don't want to use ODBC or foxpro program.
Is there any java class who can do that?
> >
> > I want to export a table from postgres into fox (foxpro 2.6) format
using
> > jdbc.
> > Has somebody an example of java code who can do that?
> >
> > Thanks!
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 5: Have you checked our extensive FAQ?
> >
> > http://www.postgresql.org/docs/faqs/FAQ.html
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
> >
>