There is only one user logging in. The web app db user.
If I have two search paths.
search_path='cust1restricted', 'cust1' and search_path='cust2restricted','cust2'
I am looking for a generic query that would look into the parent schema without having to know the parent schema
I know that I can do
select * from cust1.table
and
select * from cust2.table
but what I was wondering if there was a way to write the query based on the position in the search_path
select * from {upOneLevel}.table;
That would work for both search paths.
Thanks
Woody
