let user specify Postgres schema in the connection parameters.

[ka-ramba]

Right now all connections happen to go to the 'public' schema, which is a showstopper in many production environments. I think the Postgres connection string has search_path

[mbarnach]

I see multiple (related) issues to that:

• it would be nice to be able to create the tables on the schema you want. Currently, if you name you table like "another_schema.table_name", it doesn't generate the expected CREATE TABLE another_schema.table_name... but CREATE TABLE "another_schema.table_name"....
• There is no schema selection or ability to upgrade the search_path. Having the suggested option to select the schema at connection could be useful, but maybe not sufficient for many applications.
• If the schema part is properly escaped, all requests should be OK with another_schema.table_name. The issue for extending the protocol I can see is that, schema is used for the table name. Adding another entry that relates to the schema will be confusing...

If anybody has a good idea on how we could (safely!) bypass the escaping of names on the SQL requests, I would be happy to look at it :-)

[0xTim]

This was added in the latest version of Fluent. Update to the latest version and then you can add a new static property on your model:

final class MyModel: Model {
  static let schema = "table_name"
  static let space = "schema_name"
  // ...
}

See the docs for more details.