javadatabasepostgresqljdbcdatabase-schema

Is it possible to specify the schema when connecting to postgres with JDBC?

Is it possible? Can i specify it on the connection URL? How to do that?

Solution

  • I know this was answered already, but I just ran into the same issue trying to specify the schema to use for the liquibase command line.

    Update As of JDBC v9.4 you can specify the url with the new currentSchema parameter like so:

    jdbc:postgresql://localhost:5432/mydatabase?currentSchema=myschema

    Appears based on an earlier patch:

    http://web.archive.org/web/20141025044151/http://postgresql.1045698.n5.nabble.com/Patch-to-allow-setting-schema-search-path-in-the-connectionURL-td2174512.html

    Which proposed url's like so: 

    jdbc:postgresql://localhost:5432/mydatabase?searchpath=myschema