we use multiple schemas in a single postgresql database. (ign 7.7.x)
- Database Query Browser should delimit all tablenames on the quick double click "select * from " feature…if you have a capital in the name you have to add the quotes manually …eg select * from fred works, but not select * from Fred
There is an option to delimit columns in the translator but not for tables.
- Database Query always returns tables from all schemas - if you have lots of tables schemas are useful to segregate various tables and still maintain cross schema query capability. Using separate databases is non workable as you cannot then run queries across multiple connections.
Using your option in the database connection to include schema in table names improves things by using schema, but it displays all tables from all schemas eg similar to post https://www.inductiveautomation.com/forum/viewtopic.php?f=70&t=7149&start=0&st=0&sk=t&sd=a&hilit=translator
To get around this I tried to use the filter option to solve my issue by creating a custom translator per schema to filter out the extra table names. The filter is however applied to the table name only not the combined schema.table so it does not work as one wished.
I realise this is an edge case, but either filtering on the combined schema.tablename or filter by schema would provide more functionality.