Thread: Schema?

 

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

On Fri, 21 Jan 2005, Ing. Jhon Carrillo wrote:

> I want  to make a query without to indicate the schema name, for example:
>
>   Select  *  from  tabla where  ....
>

See the search_path server configuration variable.  It may be set at a
number of levels to indicate what schemas to look in for the requested
table.

Kris Jurka

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