Schemas, and visibility of tables in MS-Query.
От | Harry Broomhall |
---|---|
Тема | Schemas, and visibility of tables in MS-Query. |
Дата | |
Msg-id | 200309171354.OAA39300@haeb.noc.uk.easynet.net обсуждение исходный текст |
Ответы |
Re: Schemas, and visibility of tables in MS-Query.
|
Список | pgsql-novice |
One of the extras I had hoped for with PgSQL 7.3 Schemas was a somewhat cosmetic, but useful, change in the way that MS-Query sees tables in a database. What I *actualy* want to achieve is for the MS-Query browser only to show some tables from the database it is connected to. I've played with various variations on schemas, but whatever I do the browser insists on showing <All> schemas, and hence all tables. The reason I want to do this is down to support issues. The users are mostly senior management and I keep on being asked "What are these other tables and why can't I get data from them?"! It isn't easy telling such exalted people "You can't get at them because I don't want you to fiddle!". Much easier if they aren't visible. <grin> Any suggestions on how to achieve this? Details of database: PostgreSQL 7.3.4 on i386-unknown-freebsd4.5, compiled by GCC 2.95.3 ODBC driver is 'PostgreSQL' (i.e. not Legacy or Unicode etc) version 7.03.01.11. I'd rather not depend on a particular ODBC driver if I can help it! Regards, Harry.
В списке pgsql-novice по дате отправления: