James Neville <james.neville@babcockbrown.com> writes:
> Only recently, we have noticed the abscence of any schemas.
It's not possible that the database contains *no* schemas. You are
being way too imprecise in describing the problem.
> The product issues queries like:
> SELECT * FROM dbname.public.users;
> Obviously, the JDBC Driver making the SQL query fails on 'public'.
What's obvious about it? And what exactly is the error message?
I suspect you are completely misinterpreting what you are seeing.
regards, tom lane