How to use

createStatement

method

in

org.postgresql.jdbc.PgConnection

protected Statement createMetaDataStatement() throws SQLException {
 return connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
   ResultSet.CONCUR_READ_ONLY);
}

@Override
public Statement createStatement() throws SQLException {
 // We now follow the spec and default to TYPE_FORWARD_ONLY.
 return createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
}

public String getSchema() throws SQLException {
 checkClosed();
 Statement stmt = createStatement();
 try {
  ResultSet rs = stmt.executeQuery("select current_schema()");
  try {
   if (!rs.next()) {
    return null; // Is it ever possible?
   }
   return rs.getString(1);
  } finally {
   rs.close();
  }
 } finally {
  stmt.close();
 }
}

public void setSchema(String schema) throws SQLException {
 checkClosed();
 Statement stmt = createStatement();
 try {
  if (schema == null) {
   stmt.executeUpdate("SET SESSION search_path TO DEFAULT");
  } else {
   StringBuilder sb = new StringBuilder();
   sb.append("SET SESSION search_path TO '");
   Utils.escapeLiteral(sb, schema, getStandardConformingStrings());
   sb.append("'");
   stmt.executeUpdate(sb.toString());
   LOGGER.log(Level.FINE, "  setSchema = {0}", schema);
  }
 } finally {
  stmt.close();
 }
}

@Override
public Statement createStatement(int resultSetType, int resultSetConcurrency)
  throws SQLException {
 checkClosed();
 return createStatement(resultSetType, resultSetConcurrency, getHoldability());
}

protected int getMaxIndexKeys() throws SQLException {
 if (INDEX_MAX_KEYS == 0) {
  String sql;
  sql = "SELECT setting FROM pg_catalog.pg_settings WHERE name='max_index_keys'";
  Statement stmt = connection.createStatement();
  ResultSet rs = null;
  try {
   rs = stmt.executeQuery(sql);
   if (!rs.next()) {
    stmt.close();
    throw new PSQLException(
      GT.tr(
        "Unable to determine a value for MaxIndexKeys due to missing system catalog data."),
      PSQLState.UNEXPECTED_ERROR);
   }
   INDEX_MAX_KEYS = rs.getInt(1);
  } finally {
   JdbcBlackHole.close(rs);
   JdbcBlackHole.close(stmt);
  }
 }
 return INDEX_MAX_KEYS;
}

protected int getMaxNameLength() throws SQLException {
 if (NAMEDATALEN == 0) {
  String sql;
  sql = "SELECT t.typlen FROM pg_catalog.pg_type t, pg_catalog.pg_namespace n "
     + "WHERE t.typnamespace=n.oid AND t.typname='name' AND n.nspname='pg_catalog'";
  Statement stmt = connection.createStatement();
  ResultSet rs = null;
  try {
   rs = stmt.executeQuery(sql);
   if (!rs.next()) {
    throw new PSQLException(GT.tr("Unable to find name datatype in the system catalogs."),
      PSQLState.UNEXPECTED_ERROR);
   }
   NAMEDATALEN = rs.getInt("typlen");
  } finally {
   JdbcBlackHole.close(rs);
   JdbcBlackHole.close(stmt);
  }
 }
 return NAMEDATALEN - 1;
}

@Override
public Savepoint setSavepoint(String name) throws SQLException {
 checkClosed();
 if (getAutoCommit()) {
  throw new PSQLException(GT.tr("Cannot establish a savepoint in auto-commit mode."),
    PSQLState.NO_ACTIVE_SQL_TRANSACTION);
 }
 PSQLSavepoint savepoint = new PSQLSavepoint(name);
 // Note we can't use execSQLUpdate because we don't want
 // to suppress BEGIN.
 Statement stmt = createStatement();
 stmt.executeUpdate("SAVEPOINT " + savepoint.getPGName());
 stmt.close();
 return savepoint;
}

@Override
public Savepoint setSavepoint() throws SQLException {
 checkClosed();
 String pgName;
 if (getAutoCommit()) {
  throw new PSQLException(GT.tr("Cannot establish a savepoint in auto-commit mode."),
    PSQLState.NO_ACTIVE_SQL_TRANSACTION);
 }
 PSQLSavepoint savepoint = new PSQLSavepoint(savepointId++);
 pgName = savepoint.getPGName();
 // Note we can't use execSQLUpdate because we don't want
 // to suppress BEGIN.
 Statement stmt = createStatement();
 stmt.executeUpdate("SAVEPOINT " + pgName);
 stmt.close();
 return savepoint;
}

Statement statement = createStatement();
statement.execute("IDENTIFY_SYSTEM");
statement.close();

Statement stmt = connection.createStatement();
ResultSet rs = stmt.executeQuery(sql);
while (rs.next()) {

Statement stmt = connection.createStatement();
ResultSet rs = stmt.executeQuery(sql);
while (rs.next()) {

try (Statement stmt = pgConnection().createStatement()) {
  stmt.execute(String.format(
      "CREATE_REPLICATION_SLOT %s TEMPORARY LOGICAL %s",

ResultSet rs = null;
try {
 stmt = connection.createStatement();
 rs = stmt.executeQuery(sql);
 if (!rs.next()) {

@Override
public void execSQLUpdate(String s) throws SQLException {
 BaseStatement stmt = (BaseStatement) createStatement();
 if (stmt.executeWithFlags(s, QueryExecutor.QUERY_NO_METADATA | QueryExecutor.QUERY_NO_RESULTS
   | QueryExecutor.QUERY_SUPPRESS_BEGIN)) {
  throw new PSQLException(GT.tr("A result was returned when none was expected."),
    PSQLState.TOO_MANY_RESULTS);
 }
 // Transfer warnings to the connection, since the user never
 // has a chance to see the statement itself.
 SQLWarning warnings = stmt.getWarnings();
 if (warnings != null) {
  addWarning(warnings);
 }
 stmt.close();
}

Statement stmt = connection.createStatement();
ResultSet rs = stmt.executeQuery(sql);
while (rs.next()) {
            + " WHERE a.attrelid = " + returnTypeRelid
            + " AND NOT a.attisdropped AND a.attnum > 0 ORDER BY a.attnum ";
  Statement columnstmt = connection.createStatement();
  ResultSet columnrs = columnstmt.executeQuery(columnsql);
  while (columnrs.next()) {

  + " ORDER BY a.attnum ";
Statement stmt = connection.createStatement();
ResultSet rs = stmt.executeQuery(sql);
while (rs.next()) {

Statement stmt = connection.createStatement();
ResultSet rs = stmt.executeQuery(sql);
while (rs.next()) {

@Override
public ResultSet execSQLQuery(String s, int resultSetType, int resultSetConcurrency)
  throws SQLException {
 BaseStatement stat = (BaseStatement) createStatement(resultSetType, resultSetConcurrency);
 boolean hasResultSet = stat.executeWithFlags(s, QueryExecutor.QUERY_SUPPRESS_BEGIN);
 while (!hasResultSet && stat.getUpdateCount() != -1) {
  hasResultSet = stat.getMoreResults();
 }
 if (!hasResultSet) {
  throw new PSQLException(GT.tr("No results were returned by the query."), PSQLState.NO_DATA);
 }
 // Transfer warnings to the connection, since the user never
 // has a chance to see the statement itself.
 SQLWarning warnings = stat.getWarnings();
 if (warnings != null) {
  addWarning(warnings);
 }
 return stat.getResultSet();
}

   + " WHERE n.nspname  != 'pg_toast'";
Statement stmt = connection.createStatement();
ResultSet rs = stmt.executeQuery(sql);