Re: Loading an SQL command file via JDBC

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(at)servlets(dot)net>
To: <pgsql-jdbc(at)postgresql(dot)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
>
>