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.