Postgres Pro
Downloads
Home   >   mailing lists

Re: Schemas, and visibility of tables in MS-Query. - Mailing list pgsql-novice

From Harry Broomhall
Subject Re: Schemas, and visibility of tables in MS-Query.
Date
Msg-id 200310011419.PAA97616@haeb.noc.uk.easynet.net
Whole thread Raw
In response to Re: Schemas, and visibility of tables in MS-Query.  (Jeff Eckermann <jeff_eckermann@yahoo.com>)
List pgsql-novice
Tree view 
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.

pgsql-novice by date:

Previous
From: Jeff Eckermann
Date:
Subject: Re: Schemas, and visibility of tables in MS-Query.
Next
From: Tom Lane
Date:
Subject: Re: Schemas, and visibility of tables in MS-Query.