Postgres has a COPY command which does what you are trying to do. If you
manage to get it to work via JDBC I would be very interested
Dave
----- Original Message -----
From: "Tauren Mills" <tauren@servlets.net>
To: <pgsql-jdbc@postgresql.org>
Sent: Thursday, June 07, 2001 4:44 AM
Subject: [JDBC] Loading an SQL command file via JDBC
> I have a text file that contains a bunch of SQL commands. I need to
execute
> all of those commands via JDBC. Obviously, I could read the file in,
parse
> it, and execute each command one at a time. But is there a simple JDBC or
> SQL command that will simplify this and automatically load an entire list
of
> commands?
>
> For instance, I think the MySQL database has something like a "source"
> command that might do this.
>
> Thanks,
> Tauren
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl
>
>