Re: schemas for organizing tables

On 04/28/11 5:51 PM, Seb wrote:
> Hi,
>
> A database I'm handling is becoming a bit large'ish (~ 30 tables), and
> I'd like to break them down into their natural units.  Schemas for each
> of these natural units seems logical, but are they really meant for
> this?  I'm also worried about how this would affect programs like
> Libreoffice (the sdbc driver in particular)?

30 tables is really not that many.  we have schemas with 200 tables in
databases with 6 or 10 different schemas.

we use schemas to separate out data that is rarely used together,
typically each schema is for different application classes.

as far as liberoffice goes, I have no idea, but you should be able to
refer to schemaname.tablename regardless.