Setting default schema in postgresql (spring)

Question

On my own machine I modify postgresql.conf, but I don't think Heroku gives access to that file. Does anyone know any alternative methods to set the default schema?

Setting it on every connection seems kinda ugly.

If you always want to use that schema, you can make it the default schema by running alter user set schema 'default_schema' — user330315
– user330315, Commented Oct 18, 2013 at 6:23

Dark Knight · Accepted Answer · 2013-10-18 03:43:56Z

2

Create user in postgres db with same name as schema name. Login with this new user, it will automatically point to schema with user.

  <GlobalNamingResources>
  <Resource name="jdbc/DatabaseName" auth="Container" type="javax.sql.DataSource"
              username="acme" password="dbPasswd"
              url="jdbc:postgresql://localhost/mydb"
              driverClassName="org.postgresql.Driver"
              initialSize="5" maxWait="5000"
              maxActive="120" maxIdle="5"
              validationQuery="select 1"
              poolPreparedStatements="true"/>
</GlobalNamingResources/>

with this configuration, jndi lookup for resource "jdbc/DatabaseName" with return database connection pointing to schema name matching user "acme", ie acme.

answered Oct 18, 2013 at 3:43

Dark Knight

8,3574 gold badges41 silver badges58 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Setting default schema in postgresql (spring)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related