SEO

#1 (**permalink**) 04-15-2008, 11:00 PM

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

#2 (**permalink**) 04-15-2008, 11:00 PM

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

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

#3 (**permalink**) 04-15-2008, 11:00 PM

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
>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Schema?