Connecting to specific schema in PostgreSQL
Connecting to specific schema in PostgreSQL
- Subject: Connecting to specific schema in PostgreSQL
- From: Kushnir Gennady <email@hidden>
- Date: Tue, 08 Apr 2014 12:20:28 +0400
Hello list!
I am trying to move my application from mysql to postgresql and I am a bit stuck.
When reading postgres documentation I've found that I can use separate Schemas within single postgresql database.
But when I am trying to connect my models to the database I get “relation does not exist” errors as a connection does not know in which schema to search for tables.
So how should I mention a schema in a model so that it generates full table names with prefix? Or how to inject a search_path initialization code right after a database connection?
(I use separate models for different schemas)
Regards,
Gennady
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden