Forum Discussion

thatsthat's avatar
thatsthat
Contributor
3 months ago

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 bluesk...
Data-Driven Testing
  • thatsthat's avatar
    thatsthat
    3 months ago

    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=

thatsthat's avatar
thatsthat
Contributor
3 months ago

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=