powered by Jive Software

Openfire & PostgreSQL: all tables are in schema 'public'

I’ve used various software with PostgreSQL, and it generally creates a named schema. For example, when I installed Trac, it created database called trac and it put its tables in a schema called trac. But Openfire put its tables in the default ‘public’ schema in the openfire database. According to PostgreSQL documentation, all users have access to the public schemas. So how do I move the database to a named schema and make Openfire access it from there?

Hello,

All authorized users to a given database have access to the public schema. You can control which users have access to the database, so not all postgresql users have access to the openfire database.

Changing schemas is not possible, IIRC

daryl