thatsthat
20 days agoContributor
Specifying a specific Schema when connecting to Postgres Database Connection
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
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=