"Marc G. Fournier" <[EMAIL PROTECTED]> writes:
> Actually, the use of schema's was my idea, to speed up some dreadfully
> slow queries dealing with traffic stats from a table that was growing
> painfully monolithic ... the idea is/was that it would be easier to
> backup/remove all data pertaining
Actually, the use of schema's was my idea, to speed up some dreadfully
slow queries dealing with traffic stats from a table that was growing
painfully monolithic ... the idea is/was that it would be easier to
backup/remove all data pertaining to a specific client if they decided to
close their acc
"Marc G. Fournier" <[EMAIL PROTECTED]> writes:
>> How else would you expect it to work?
> List of relations
> Schema | Name | Type | Owner
> --+---+--+---
> public | categories| table| 18
Chris,
> I work with Marc Fournier, for those who don't know, and have been
> working extensively with the schemas feature for Hub.Org's new Account
> Management package. Each client's data is stored in a seperate schema
> set asside just for them (though they will never have direct access to
> i
On Wed, 5 Nov 2003, Tom Lane wrote:
> Chris Bowlby <[EMAIL PROTECTED]> writes:
> > As you can see this is a nice, clean way to break down some datasets.
> > But, if I do:
>
> > set search_path to public, test_001, test_002;
>
> > I only get access to the tables in test_001 and public, the tab
Chris Bowlby <[EMAIL PROTECTED]> writes:
> As you can see this is a nice, clean way to break down some datasets.
> But, if I do:
> set search_path to public, test_001, test_002;
> I only get access to the tables in test_001 and public, the tables in
> test_002 are not listed, and thus I do not
On Wed, 5 Nov 2003, Jan Wieck wrote:
> Chris Bowlby wrote:
>
> > Hi All,
> >
> > I work with Marc Fournier, for those who don't know, and have been
> > working extensively with the schemas feature for Hub.Org's new Account
> > Management package. Each client's data is stored in a seperate schem
Chris Bowlby wrote:
Hi All,
I work with Marc Fournier, for those who don't know, and have been
working extensively with the schemas feature for Hub.Org's new Account
Management package. Each client's data is stored in a seperate schema
set asside just for them (though they will never have direc
Hi All,
I work with Marc Fournier, for those who don't know, and have been
working extensively with the schemas feature for Hub.Org's new Account
Management package. Each client's data is stored in a seperate schema
set asside just for them (though they will never have direct access to
it, it he