Sunil Vasanta wrote: > I want application to access multiple scheme based on call context but only one user is created for > application and application should access different schema using same user privilege and credentials. > > is this possible in Postgres. Plz share u thoughts. > > If possible then how to configure search path. That shouldn't be a problem. Just issue SET serach_path = <whatever> after you have determined the context. Yours, Laurenz Albe -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin