Specifying a specific Schema when connecting to Postgres Database Connection

Question

Hi all .. I have no trouble connecting my ReadyAPI application to a Postgres database. However, I need to specify a specific schema to connect to. Say the schema i need to connect to is called bluesky how do i modify my connection string so that the queries hit that specific schema?

jdbc:postgresql://0.0.0.1:5432/oompaloompa?user=player1&password=PASS_VALUE

thatsthat · Accepted Answer

Found the solution add 'searchpath' to the connection string like this:

jdbc:postgresql://0.0.0.1:5432/oompaloompa?searchpath=bluesky&user=player1&password=PASS_VALUE

or instead of searchpath=

use currentSchema=

Forum Discussion

Specifying a specific Schema when connecting to Postgres Database Connection

1 Reply

Recent Discussions

Vulnerable jetty files

RunTestCase input and return proeprties of the same name

Import API Definition in Ready API

Related Content

Connection reset

javax.net.ssl.SSLException: Connection reset error

LDAPS connection