On 03/29/12 2:16 PM, Thomas Kellerer wrote:
Jonathan Bartlett wrote on 29.03.2012 22:39:
Your suggestion gives me an idea, and I'd like your opinion since I
haven't done much with schemas.
(1) Separate the datasets into different schemas
(2) Use different schema names for different static data releases
(3) For the *company*, we can use a schema search path that includes
the next schema
(4) For the *users*, they can use a schema search path that includes
the released schema
Then, I wouldn't have to modify any code, except to set the schema
search path based on who was connecting.
If you create different Postgres users, you can set the search_path
per user, so you don't have to remember doing that while connecting.
heck, the default search_path is $USER,"public"
--
john r pierce N 37, W 122
santa cruz ca mid-left coast
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
