From: Scott Marlowe <scott.marlowe@gmail.com>
To: Daniel Caune <daniel.caune@ubisoft.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Using schema
Date: Fri, 30 Nov 2007 21:33:06 -0600
Message-ID: <dcc563d10711301933q3bfdeed0n36dc3afefca9efae@mail.gmail.com> (raw)
In-Reply-To: <1E293D3FF63A3740B10AD5AAD88535D2068E27F3@UBIMAIL1.ubisoft.org>
References: <1E293D3FF63A3740B10AD5AAD88535D2068E27F3@UBIMAIL1.ubisoft.org>
On Nov 30, 2007 9:00 AM, Daniel Caune <daniel.caune@ubisoft.com> 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; -- Uses schema my_schema
> SELECT * FROM bar; -- Uses schema public
> SELECT * FROM foo, bar WHERE foo.i = bar.i; -- Uses both schemas
>
> That is damn flexible! :-)
Hehe. yeah, every time I have to use Oracle at work I feel like I'm
putting on a straight jacket.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: scott.marlowe@gmail.com, daniel.caune@ubisoft.com
Subject: Re: Using schema
In-Reply-To: <dcc563d10711301933q3bfdeed0n36dc3afefca9efae@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox