How do I capture command output in PostgreSQL using a JDBC connection?

Question

If I run a PostgreSQL command that generates output as a stream of text, such as vacuum full verbose analyze, how do I capture its output using a JDBC connection?

score 2 · Accepted Answer · 2015-03-03 22:30:28Z

2

This is available in the warnings of the Statement object that was used to run the command:

Statement stmt = connection.createStatement();
stmt.execute("vacuum verbose foobar");
SQL Warning warn = stmt.getWarnings();
if (warn != null)
{
  System.out.println(warn.getMessage);
}

Theoretically there can be chained warnings, so you might want to use a loop, that checks SQLWarning.getNextWarning(). Check the JDK JavaDocs for more details.

edited Mar 3, 2015 at 22:30

answered Mar 3, 2015 at 22:20

user330315

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How do I capture command output in PostgreSQL using a JDBC connection?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related