Mike Diehl wrote: > 1. Create a table for each spreadsheet, using column headings as field > names. > Every field would be a char/varchar. We might have a table to track which > client owns which table. This could amount to 10's of tables being added to > the db.
Give each client their own schema. Set permissions on the whole schema. You should be fine with a few dozen or a few hundred tables. You can also dump/restore a whole schema then. -- Richard Huxton Archonet Ltd -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
