Support for schemas

[dennislaumen]

Is there a reason that this module does not support PostgreSQL's schema's? We're looking into using Puppet to manage a PostgreSQL setup which is a bit more involved and are missing support for schema's in this (and other Puppet modules for PostgreSQL).

Thanks for all the great modules, keep up the good work!

[alvagante]

To be honest I'm not a PostgreSQL master and I even don't exactly know what's the difference between a database and a schema on PostgreSQL.

Anyway, for the first one there's a specific define which might be used:
https://github.com/example42/puppet-postgresql/blob/master/manifests/dbcreate.pp

For a schema I suppose a new define might be done based on a similar approach, or as a general workaround you can generically import a file with whatever query you need, with:
https://github.com/example42/puppet-postgresql/blob/master/manifests/import.pp

[dennislaumen]

Thanks for the quick response! I'm still evaluating several Puppet modules. I'll close this issue for now as I won't add this functionality in the short term, but should I land on this module and add something generic I'll send you a PR.