Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Schemas and views
3 views
Skip to first unread message
Darryl Pye
Jan 27, 2013, 6:02:26 AM1/27/13
to
Hi,
I have a multi-tenant application that users a schema per client to separate data and some functionality.
I can run functions declared in the public schema and only the appropriate tables in the schema that I have set with search_path get affected, and want to use the same principal with views however
views always have schema qualified tables.
I have downloaded the source for postgres and am stepping through the code to try and get an understanding on how it fits together, and was looking for some advice on the best way to approach this problem.
Regards,
Darryl
I have a multi-tenant application that users a schema per client to separate data and some functionality.
I can run functions declared in the public schema and only the appropriate tables in the schema that I have set with search_path get affected, and want to use the same principal with views however
views always have schema qualified tables.
I have downloaded the source for postgres and am stepping through the code to try and get an understanding on how it fits together, and was looking for some advice on the best way to approach this problem.
Regards,
Darryl
0 new messages