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.
-- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
