Re: Missing schema name

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
>