I have a Windows application that needs to integrate to an existing PostgreSQL 8.1 database. I'm using the OLE driver from http://www.pgoledb.com/.
This particular application tries to load the details of every table even though it only needs access to one. If I don't grant the user permission to select from all of these tables, the application throws an error as it tries to load each one. If I do grant the user permission to select from all of these tables, the application loads all of their meta data very slowly.
I can't seem to find a way to "hide" most of the tables so that the application won't even know they exists and won't try to do anything with them. Does such a feature/permission exist? Would creating another schema help (there's currently just one "public" schemea)? Is there a OLE feature that might help?
(Note I don't really care if the application can access these tables from a security standpoint, I just want to speed things up for the users of this app.)