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<br/>When I look at any table in any of the schemas, the table name has the schema prepended to it.<br
/><br/>If it isn't PgAdmin doing it, then it must be in the Pg server itself.<br />How does PgAdmin get the DDL for a
tablefrom the server?<br /><br /><div class="gmail_quote">On Thu, Aug 11, 2011 at 2:14 PM, Guillaume Lelarge <span
dir="ltr"><<ahref="mailto:guillaume@lelarge.info">guillaume@lelarge.info</a>></span> wrote:<br /><blockquote
class="gmail_quote"style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">On Thu, 2011-08-11 at 09:42
-0500,Little, Douglas wrote:<br /> > We're setting up a new machine.<br /> > From pgadmin when I look at the old
machine tables, the schema name is displayed in the screen<br /> > [cid:image001.png@01CC580A.FFB1A050]<br />
><br/> ><br /> > When looking at the new machine, the schema name is not displayed.<br /> >
[cid:image002.png@01CC580A.FFB1A050]<br/> ><br /> > Visually, it's not a problem. But I do lots of cut/paste and
needthe schema name to show up.<br /> > Any thoughts why it's not.<br /> ><br /><br /> Guess you have different
search_pathon these servers.<br /><br /><br /> --<br /> Guillaume<br /> <a href="http://blog.guillaume.lelarge.info"
target="_blank">http://blog.guillaume.lelarge.info</a><br/> <a href="http://www.dalibo.com"
target="_blank">http://www.dalibo.com</a><br/><font color="#888888"><br /><br /> --<br /> Sent via pgadmin-support
mailinglist (<a href="mailto:pgadmin-support@postgresql.org">pgadmin-support@postgresql.org</a>)<br /> To make changes
toyour subscription:<br /><a href="http://www.postgresql.org/mailpref/pgadmin-support"
target="_blank">http://www.postgresql.org/mailpref/pgadmin-support</a><br/></font></blockquote></div><br />