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

by

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

More Related Contents:

  1. How to get a value from the last inserted row? [duplicate]
  2. how to copy data from file to PostgreSQL using JDBC?
  3. proper hibernate annotation for byte[]
  4. How to get all table names from a database?
  5. how can I create new XML file from existing database in PostgreSQL database using java [closed]
  6. How is driver class located in JDBC4
  7. org.postgresql.util.PSQLException: FATAL: sorry, too many clients already
  8. What is the most recommended way to store time in PostgreSQL using Java?
  9. How to read all rows from huge table?
  10. Setting Network Timeout for JDBC connection
  11. No results returned by the Query error in PostgreSQL
  12. Driver JDBC PostgreSQL with Android [duplicate]
  13. how to get list of Databases “Schema” names of MySql using java JDBC
  14. How do I use PostgreSQL JSON(B) operators containing a question mark “?” via JDBC
  15. How to simulate a DB for testing (Java)?
  16. Java JDBC ignores setFetchSize?
  17. com.mysql.jdbc.PacketTooBigException
  18. XML data to PostgreSQL database [closed]
  19. Does a ResultSet load all data into memory or only when requested?
  20. How do I unit test jdbc code in java? [closed]
  21. Java PreparedStatement UTF-8 character problem
  22. Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]
  23. Convert a Result Set from SQL Array to Array of Strings
  24. Postgres UUID JDBC not working
  25. java.lang.ClassNotFoundException: com.mysql.jdbc.Driver in Eclipse
  26. UNIQUE constraint failed: sqlite database : android
  27. PSQLException: ERROR: relation “TABLE_NAME” does not exist
  28. MyBatis executing multiple sql statements in one go, is that possible?
  29. A persistent connection with JDBC to MySQL
  30. Getting Hibernate and SQL Server to play nice with VARCHAR and NVARCHAR

Leave a Comment