How to select a specific Postgres schema with reactive datasource in Quarkus

[jaiprasad266]

Today with the below configuration it is connecting to the default schema of a db , how to configure to connect to a specific schema.

quarkus.datasource.db-kind = postgresql
quarkus.datasource.username = ${DB_USERNAME:postgres}
quarkus.datasource.password = ${DB_PASSWORD:postgres}
quarkus.datasource.reactive.url = ${DB_URL:postgresql://localhost:5432/sampledb}

here by default it is fetching data from default/public schema , now how do u connect to say schema user1 within sampledb.

how can we do this through quarkus reactive datasource configuration . It is possible through plain PGSimpleDataSource

PGSimpleDataSource ds = new PGSimpleDataSource();
ds.setServerNames( new String[] { "localhost" } );
ds.setPortNumbers( new int[] { 5432 } );
ds.setDatabaseName( "sampledb" );
ds.setCurrentSchema("user1");
ds.setUser( "postgres" );
ds.setPassword( "postgres" );

references :

https://quarkus.io/guides/reactive-sql-clients#postgresql-2

Any help or suggestion would be really helpful

[jaiprasad266]

Adding search_path to the connection uri will fetch results from specific schema.

postgresql://localhost:5432/sampledb?search_path=user1