How to get results of select query in postgresql r2dbc?

Question

I can execute this query just fine but I don't know how to extract the information returned by the select statement.

Flux<PostgresqlResult> checkTableQuery = connectionMono.flatMapMany(connection -> connection
    .createStatement("select exists(\n" +
                " select table_name from information_schema.tables\n" +
                " where table_name='sequence1'\n" +
                ");")
        .execute());
checkTableQuery.subscribe();

use subscribe() to subscribe to the suscription, check [Flux Subscriber java doc](https://projectreactor.io/docs/core/release/api/reactor/core/publisher/Flux.html#subscribe-reactor.core.CoreSubscriber-) — Hantsy, Jun 04 '21 at 06:26

score 1 · Accepted Answer · edited Aug 03 '22 at 09:06

Flux<PostgresqlResult> checkTableQuery = connectionMono.flatMapMany(connection -> connection
.createStatement("select exists(\n" +
            " select table_name from information_schema.tables\n" +
            " where table_name='sequence1'\n" +
            ");")
    .execute())
.flatmap(result -> result.map(
  (row,rowMetadata) -> row.get("exists",Boolean.class)));

checkTableQuery.subscribe();

How to get results of select query in postgresql r2dbc?

1 Answers1