On Nov 30, 2007 9:00 AM, Daniel Caune <[EMAIL PROTECTED]> wrote:
> The cool thing with this, compared to the USE statement supported by
> some other RDBMS, is that the user is not restricted to one given schema
> without explicit schema declaration:
>
> SELECT * FROM foo;
Hi,
I tried to figure out how to select a particular schema before executing
statement on its objects without having to specify the schema in these
statements (cf. the instruction USE supported in some other RDBMS)
PostgreSQL allows modifying dynamically the schema search path:
SET search_path
