Forum Discussion

thatsthat's avatar
thatsthat
Contributor
20 days 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 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=

  • 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=