Database Schema other than public

[RVijay007]

Hi, I'm using Vapor 3 to build a swift server that connects to an existing db within our organization. I've read the docs on how to connect to an existing database, but I'm still unclear on how to hook up Models to a specific schema. It seems to always use the public db schema; how can I use a schema other than public?

We use Postgres as our database.

[0xTim]

If you configure your Postgres DB as normal in Vapor and then set the defaultDatabase property on the model it should work. (Also, don’t use a migration)

Details here https://forums.swift.org/t/new-to-swift-and-vapor-returning-data-from-mysql/13088

[RVijay007]

I do that with a test db, but it is picking up only tables made in the public schema, and I'm not sure how to get it to use one of our other schema groupings instead. The database is going to be the same both ways, so I'm not sure why changing defaultDatabase is going to do anything. I'm looking for configuration of the schema parameter, such as when we write SQL queries:

SELECT
*
FROM
<schema>.<table>

I see that Models map to Tables, and the connection contains the database information, but what holds the schema information that can be configured dynamically (not static).

[fwgreen]

@RVijay007 This issue is driver related and is finally (hopefully) being addressed.

[tanner0101]

Closing here in favor of vapor/postgres-kit#9. There are a couple of good workarounds there in the interim.