2008/7/1 Ramesh <[EMAIL PROTECTED]>: > Actually my requirement is that i want to convert a text file from > postgre sql \copy command to a table in sqlite
.import is a shell command, and is thus unavailable through the SQLiteJDBC driver. One easy way to solve this problem is to load the file into a PostgreSQL table, then open a JDBC connection to both the PostgreSQL db and to the SQLite db. Call a 'select *' on the first db and enumerate the entries calling 'insert into' on the SQLite db. d. --~--~---------~--~----~------------~-------~--~----~ Mailing List: http://groups.google.com/group/sqlitejdbc?hl=en To unsubscribe, send email to [EMAIL PROTECTED] -~----------~----~----~----~------~----~------~--~---
