PostgreSQL Schema

[robinson-rso]

Is Relational capable of dealing with PostgreSQL Schemas? I am not sure if I can map the schemas and tables properly. I have used variables instead methods to map schemas:

$vendor = 'og0001.vendor';
$array = $mapper->$vendor->fetchAll();

Will Relational support schemas?

Thanks!

[nickl-]

Relational uses PDO so anything that PDO supports should work as expected.

Please let us know what you find, I do know that it works on MySQL and Sqlite but haven't personally tested the rest.

[robinson-rso]

There are several databases that supports PDO, but there are some important differences between PostgreSQL and MySQL. Including the fact that PostgreSQL supports schemas (whereas MySQL uses separate database). Some ORMs like Doctrine for example, is capable of dealing with this.

https://groups.google.com/forum/#!topic/doctrine-user/qFid2rgRH-s

[nickl-]

AFAIK PDO does not make any special provisioning for PostgreSQL schemas and I would imagine that they are simply treated the same way as MySQL would for databases. That said I am not sure if we can do different databases or not?

We have not tested on postgres and I think we should also ensure that mapper works across multiple databases.

@robinson-rso thank you for pointing this out, please don't hesitate to bring more items under scrutiny. You may consider this a huge contribution. something we likely would not have considered on our own for a long time.

Thank you for your help!