If you right click on the database, and select properties, under the variables tab, there is a search_path variable in the Variable Name pulldown.
On Thu, Aug 11, 2011 at 4:01 PM, Guillaume Lelarge
<guillaume@lelarge.info> wrote:
On Thu, 2011-08-11 at 15:26 -0500, Little, Douglas wrote:
> That worked, but I'm confused why it worked.
> On the new machine, I'm using gpadmin which does have different search_path.
> When I switch to my regular id, the schema name shows up.
>
> In pgadmin, is it even possible to change the search_path?
>
Nope, I don't think you can.
