Skip site navigation (1) Skip section navigation (2)

Re: Missing schema name

From: Michael Shapiro <mshapiro51(at)gmail(dot)com>
To: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
Cc: "Little, Douglas" <DOUGLAS(dot)LITTLE(at)orbitz(dot)com>, "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Missing schema name
Date: 2011-08-11 19:38:30
Message-ID: CAGCvxeb4GzmqB3JSO_X=DYcSyp7moba4mdGM3pJca2ioKoSXsQ@mail.gmail.com (view raw or flat)
Thread:
Lists: pgadmin-support
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.
How does PgAdmin get the DDL for a table from the server?

On Thu, Aug 11, 2011 at 2:14 PM, Guillaume Lelarge
<guillaume(at)lelarge(dot)info>wrote:

> 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(dot)png(at)01CC580A(dot)FFB1A050]
> >
> >
> > When looking at the new machine, the schema name is not displayed.
> > [cid:image002(dot)png(at)01CC580A(dot)FFB1A050]
> >
> > Visually, it's not a problem.  But I do lots of cut/paste and need the
> schema name to show up.
> > Any thoughts why it's not.
> >
>
> Guess you have different search_path on these servers.
>
>
> --
> Guillaume
>  http://blog.guillaume.lelarge.info
>  http://www.dalibo.com
>
>
> --
> Sent via pgadmin-support mailing list (pgadmin-support(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-support
>

In response to

Responses

pgadmin-support by date

Next:From: Guillaume LelargeDate: 2011-08-11 20:19:58
Subject: Re: pgAdmin III 3-1.14.0-beta3 crash
Previous:From: Guillaume LelargeDate: 2011-08-11 19:14:59
Subject: Re: Missing schema name

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group