well, you could add the schemas you work with into your path. Just open postgresql.conf, search for a line like this:
search_path = '$user,public' # schema names and add your schema names to the list. This should do what you want.
Ing. Jhon Carrillo wrote:
I want to make a query without to indicate the schema name, for example:
Select * from tabla where ....
and not
select * from schema.tabla where ...
not to show the shema or system tables from odbc and jdbc
can you help me?
thanks