PostgreSQL database vs. schema issue

[weecology]

PostgreSQL database vs. schema issue

[ethanwhite]

Thanks for the feedback Kate. Can you think of a use case where placing tables from different datasets into the same schema would be better than keeping them in different schemas?

[fluby]

It's really just a matter of organizational tastes, I think. In trying to design a database structure for my team, I have a number of schemas, with one of them being 'existing_data'. Purely in the interest of organization, I would like external data sets that have one (or up to 3) tables to be placed in that schema. Lots of schemas = more clutter, and more coding.

[ethanwhite]

That certainly seems reasonable.

[bendmorris]

Sounds good. I'm not a postgres user, so I don't really have a feel for how people like to organize their data. It would be easy to give users the option of specifying a schema and naming the tables something like "dataset_table" similar to how it's done in sqlite and access.

[bendmorris]

You can now specify a database name format (or schema format in postgres) and table name format using the connection settings or from the command line.