On Thu, 2011-08-11 at 16:08 -0500, Michael Shapiro wrote:
> 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.
>
Yes, but this changes every connection to this DB, not only the pgadmin
ones (it doe
On Thu, 2011-08-11 at 14:38 -0500, Michael Shapiro wrote:
> I have multiple schemas in my database. I do not have a search_path set for
> the database (so it wouold use the default: $user,public
> When I look at any table in any of the schemas, the table name has the
> schema prepended to it.
>
>
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
wrote:
> On Thu, 2011-08-11 at 15:26 -0500, Little, Douglas wrote:
> > That worked, but I'm confuse
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 s
I have multiple schemas in my database. I do not have a search_path set for
the database (so it wouold use the default: $user,public
When I look at any table in any of the schemas, the table name has the
schema prepended to it.
If it isn't PgAdmin doing it, then it must be in the Pg server itself.
On Thu, 2011-08-11 at 09:42 -0500, Little, Douglas wrote:
> We're setting up a new machine.
> From pgadmin when I look at the old machine tables, the schema name is
> displayed in the screen
> [cid:image001.png@01CC580A.FFB1A050]
>
>
> When looking at the new machine, the schema name is not di
We're setting up a new machine.
>From pgadmin when I look at the old machine tables, the schema name is
>displayed in the screen
[cid:image001.png@01CC580A.FFB1A050]
When looking at the new machine, the schema name is not displayed.
[cid:image002.png@01CC580A.FFB1A050]
Visually, it's not a p
