This topic is locked
[SOLVED]

 Is it possible to rename a template schema?

9/13/2017 1:38:25 PM
PHPRunner General questions
johnnlenon author

Hello, I have the following scenario:
1 - I use PHPRunner to generate reports from a Postgres database that is read only, that is, the user only sees the data and no modifications are allowed;
2 - I have several databases on my server, each of them has its specific schema, for example, a database called test has its schema called test_schema, a database called stock has its schema called stock_schema;
3 - I created a project based on the database called test, everything happens right, in the end I saved as a template to be able to use in other databases, everything happens without errors;
4 - But when creating a new project and using the template it loads the schema called test_schema and I need to replace table by table with the schema name, I do this in the Query tab, after doing that everything works perfectly;
But this is very laborious because I have several tables, the question is this:
Is there a way to rename the schema of the model at one time rather than rename table by table?
Thank you very much in advance.