Re: [JDBC] Schema?

[Franco Bruno Borghesi <franco(at)akyasociados(dot)com(dot)ar>]

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