|From:||Harry Broomhall <harry(dot)broomhall(at)uk(dot)easynet(dot)net>|
|Subject:||Schemas, and visibility of tables in MS-Query.|
|Views:||Raw Message | Whole Thread | Download mbox | Resend email|
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
I'd rather not depend on a particular ODBC driver if I can help it!
|Next Message||Smitha V. Babu||2003-09-18 05:17:35||tutorial for win32 programming|
|Previous Message||wireless||2003-09-17 13:07:05||Re: Connection String in ASP.NET application|
|Next Message||Tom Lane||2003-09-17 14:26:32||Re: observations about temporary tables and schemas|
|Previous Message||Relaxin||2003-09-17 08:17:47||Re: how to compile the odbc source?|