Re: Schemas, and visibility of tables in MS-Query.

From: Harry Broomhall <harry(dot)broomhall(at)uk(dot)easynet(dot)net>
To: jeff_eckermann(at)yahoo(dot)com (Jeff Eckermann)
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Schemas, and visibility of tables in MS-Query.
Date: 2003-10-01 14:19:20
Message-ID: 200310011419.PAA97616@haeb.noc.uk.easynet.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice pgsql-odbc

Jeff Eckermann writes:
>
> AFAIK (I haven't done this myself), you can issue a
> "set search path" command in the "Connect Settings"
> box in the DSN, which will limit the schemas seen to
> whatever you put in the search path list.

Nice idea - I hadn't spotted that in the driver config!
Unless I'm doing it wrong though I've just tried it and it doesn't work! :-(

Regards,
Harry.

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Jeff Eckermann 2003-10-01 14:40:42 Re: [NOVICE] Schemas, and visibility of tables in MS-Query.
Previous Message Jeff Eckermann 2003-10-01 14:03:55 Re: Schemas, and visibility of tables in MS-Query.

Browse pgsql-odbc by date

  From Date Subject
Next Message Nowland, Belinda (London) 2003-10-01 14:21:20 How do I unsubscribe?
Previous Message Jeff Eckermann 2003-10-01 14:18:03 Re: FUD!! ODBC will not be supported by Microsoft in the future