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

java database postgresql jdbc database-schema
marcosbeirigo picture marcosbeirigo · Nov 12, 2010 · Viewed 184k times · Source

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

Answer

Hiro2k picture Hiro2k · Jan 27, 2011

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

Related questions

How to create a database with flyway?

Question: Is it possible to create a new DB in a migration script and then connect to it? How? My Scenario: I'm trying to use flyway in my Java project (RESTful application using Jersey2.4 + tomcat 7 + PostgreSQL 9.3.1 + EclipseLink) for managing the …

Read More
What is the max JDBC batch size?

I have a list and that list increasing continuously. I am doing add batch depend on the list size. I forgot to put limit for do executeBatch in specified size. Program is working for hours. I dont want to stop, …

Read More
how to copy a data from file to PostgreSQL using JDBC?

I want to copy data from file to PostgreSQL DB using JDBC. I was using JDBC statement object to copy the file into DB. It is very slow. I came to know that we can also use copy out command …

Read More