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 <guilla...@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. > >
