Multi Schema(PostgreSQL)

Server Side Components
#1

Hi,

Currently the dmxDatabase.php file only looks at public schema which can be changed to show all schemas contents. But the queries generated by the framework does not include the schema name.

While one can change the search_path within Postgres, this does not work if there tables with the same name across multiple schemas. <- which is the case for a project.

So the question is, is there a way to use multiple schemas, or can i change something that adds the schema name to the table name when the metadata is refreshed?

Regards,

Nick

#2
#3

A friendly bump on this, @Teodor, @patrick,

Has more to do with that if it’s something simple to do with the framework, then i can continue with the current setup else i need to switch the objects to the public schema to continue.

Thanks in advance.

Regards,

Nick

#4

The database connector was developed for simple databases normally used on the web. Schemas are not often used unless you have some very complex data structure. I will investigate if it would be possible to easily support schemas within our database connector.

1 Like
#5

Thank you Patrick.

I know what to do to continue ans will wait for further comments.

Regards,

Nick

#6

@patrick, with the latest update, which is awesome!, it seems to lent itself for multi schema capabilities. so i was wondering if you had time investigating this besides your busy schedule.

1 Like