On Jul 1, 2:36 pm, Ramesh <[EMAIL PROTECTED]> wrote:
> Actually my requirement is that i want to convert a text file from
> postgre sql \copy command to a table in sqlite
Not sure exactly what you want. Provided the SQL syntax matches,
you can "import" a SQL file into a SQLite database with something like
this:
FileReader input = new FileReader("data.sql");
BufferedReader bufRead = new BufferedReader(input);
String line = null;
Statement stmt = conn.createStatement();
while ((line = bufRead.readLine()) != null)
stmt.executeUpdate(line);
--~--~---------~--~----~------------~-------~--~----~
Mailing List: http://groups.google.com/group/sqlitejdbc?hl=en
To unsubscribe, send email to [EMAIL PROTECTED]
-~----------~----~----~----~------~----~------~--~---
