>negora <negora(at)negora(dot)com> wrote:
> I even might return the entire result to my external Java
> application
You are probably going to want to configure it to use a cursor, at
least if the result set is large (i.e., too big to cache the entire
result set in memory before you read the first row). Read this over
carefully:
http://jdbc.postgresql.org/documentation/84/query.html#query-with-cursor
You don't have to use a Java cursor or do anything procedurally
there, but a PostgreSQL cursor is the only way to stream the data to
the application on demand (ResultSet.next), rather than pushing it
all there during the Statement.execute().
-Kevin