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.  (Harry Broomhall <harry.broomhall@uk.easynet.net>)
Список 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 по дате отправления:

Предыдущее
От: Noel
Дата:
Сообщение: Synchronising databases replication
Следующее
От: wireless200@yahoo.com (wireless)
Дата:
Сообщение: Re: Connection String in ASP.NET application