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

Question

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

User · Answer

I submitted an updated version of a patch to the PostgreSQL JDBC driver to enable this a few years back. You'll have to build the PostreSQL JDBC driver from source (after adding in the patch) to use it:

http://archives.postgresql.org/pgsql-jdbc/2008-07/msg00012.php

http://jdbc.postgresql.org/

User · Answer

I don t believe there is a way to specify the schema in the connection string   It appears you have to execute  set search path to  schema    after the connection is made to specify the schema

User · Answer

Don t forget SET SCHEMA  myschema  which you could use in a separate Statement     SET SCHEMA  value  is an alias for SET search path TO value  Only one   schema can be specified using this syntax    And since 9 4 and possibly earlier versions on the JDBC driver  there is support for the setSchema String schemaName  method

User · Answer

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

User · Answer

As of version 9 4  you can use the currentSchema parameter in your connection string   For example   jdbc postgresql   localhost 5432 mydatabase currentSchema myschema

User · Answer

If it is possible in your environment  you could also set the user s default schema to your desired schema   ALTER USER user name SET search path to  schema

User · Answer

DataSource     setCurrentSchema  When instantiating a DataSource implementation  look for a method to set the current default schema    For example  on the PGSimpleDataSource class call setCurrentSchema   org postgresql ds PGSimpleDataSource dataSource   new org postgresql ds PGSimpleDataSource      dataSource setServerName    localhost     dataSource setDatabaseName    your db here      dataSource setPortNumber   5432    dataSource setUser    postgres     dataSource setPassword    your password here     dataSource setCurrentSchema    your schema name here           lt ----------   If you leave the schema unspecified  Postgres defaults to a schema named public within the database  See the manual  section 5 9 2 The Public Schema  To quote hat manual      In the previous sections we created tables without specifying any schema names  By default such tables  and other objects  are automatically put into a schema named    public     Every new database contains such a schema

User · Answer

In Go with  sql DB   note the search path with underscore    postgres   user password host dbname sslmode disable amp search path schema

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

Examples related to java

Examples related to database

Examples related to postgresql

Examples related to jdbc

Examples related to database-schema