RE: postgresql and dynamically changing the schema per query

[S Ahmed]

Hello

I want to build a golang based service that will connect to 1 or more postgresql database servers.

For multi-tenancy, I need to separate clients into their own schema.

Is there a way for me to dynamically change the schema on a per query basis with any of the existing libraries?

[Robert Johnstone]

Hello,

I'm not an expert with PostgreSQL, but you should be able to handle changes to the schema with any library that provides support for passing raw SQL queries to the database.  See, for example, section 5.7.3 in the documentation.  I suspect nearly any package listed on godoc.org should handle this.

[palaniappan meiyappan]

Hi,

I have a similar issue.

Can you please post the solution if any?

Thanks.

[Rodrigo Kochenburger]

You can change the schema search path for that specific session/connection[1].

i.e. db.Exec("SET search_path TO myschema")

I'm not sure how this will play w/ database/sql's connection pooling because the setting is per connection, so that might not work.

Might be just easier to provide each client with their own database, instead of just schemas, which is also probably a good idea anyway.

http://www.postgresql.org/docs/8.2/static/ddl-schemas.html#DDL-SCHEMAS-PATH

- RK

--
You received this message because you are subscribed to the Google Groups "golang-nuts" group.
To unsubscribe from this group and stop receiving emails from it, send an email to golang-nuts...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.