> > > > > In my mind the point of the "database" concept is to
> > > provide a domain
> > > > > within which custom datatypes and functions are available.
> > > >
> > >
> > > AFAIK few users understand it and many users have wondered
> > > why we couldn't issue cross "database" queries.
> >
> > Imho the same issue is access to tables on another machine.
> > If we "fix" that, access to another db on the same instance is just
> > a variant of the above.
> >
>
> What is a difference between SCHAMA and your "database" ?
> I myself am confused about them.
"my *database*" corresponds to the current database, which is created with
"create database" in postgresql. It corresponds to the catalog concept in
SQL99.
The schema is below the database. Access to different schemas with one
connection
is mandatory. Access to different catalogs (databases) with one connection
is not mandatory,
but should imho be solved analogous to access to another catalog on a
different
(SQL99) cluster. This would be a very nifty feature.
Andreas