On Wed, Feb 26, 2014 at 11:24 PM, itishree sukla <itishree.sukla@xxxxxxxxx> wrote: > Hi all, > > I am in a requirement to have multiple schema in one Database. > > Schema structure will be same with respect to DB all db objetcs like tables, > procedure. > > However each schema will be accessed by one one application. > > Problem is as all DB objects are same, when application is calling to a > schema we have set search_path='schema name' in our procedure level. Now we > want to get rid of that. > > I know we have do it based on ROLE Level, question is having more than one > user defined schema is it achievable, i have done a small exercise, seems to > be it is taking the first schema defined in the set search_path. > > As i am in urgent need of it, please help me. You can alter user to each one have their own search path. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
