Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 0A3672E0072 for ; Sun, 27 Apr 2008 18:33:40 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 11436-10 for ; Sun, 27 Apr 2008 18:33:35 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from web54304.mail.re2.yahoo.com (web54304.mail.re2.yahoo.com [206.190.49.114]) by developer.postgresql.org (Postfix) with SMTP id 9C5682E006E for ; Sun, 27 Apr 2008 18:33:34 -0300 (ADT) Received: (qmail 37127 invoked by uid 60001); 27 Apr 2008 21:33:33 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=GFFBic7tsBI2o+O24rI84uu+iapCn8Prmr1B6x2tmzteL+UiaPtKexFRKnCM1JrFg9iYLEgtuSEJBjj7szeDSPVUeSnXy1O2pgk7ZqT3D8jt+eLN0nn75RrTesp5gN2Vz3hB0km/mOu0jPMzB7IGpKOrgWvc9JOBthA2Zn8HTkc=; X-YMail-OSG: gKpeUVkVM1kGe6pkOd7vSOoMs4EeeU6SkdLDYP4_iWkKxarGJgC.HfmtojJ_xpQ7LC0B5IgBYyE7Aa3LLvaKxAMLHlnZChFrAuxkWZrsKseXDDGDH_4lILmuVA-- Received: from [69.227.19.53] by web54304.mail.re2.yahoo.com via HTTP; Sun, 27 Apr 2008 14:33:33 PDT Date: Sun, 27 Apr 2008 14:33:33 -0700 (PDT) From: chester c young Subject: psql: no schema info To: sql pgsql MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <211388.34374.qm@web54304.mail.re2.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200804/207 X-Sequence-Number: 30746 have several schemae, each with identical tables. in create scripts have been taking great care to fully qualify, eg, col1 references schema1.tab1( col1 ) however, just got burnt big time on sequences! need to qualify them as well, eg col1 integer default nextval( 'schema1.seq1' ) \dt is no help at all since it does not specify schema so it's impossible to know if all is aligned correctly. is there a way to tell psql to fully qualify relations in the listing? when everything was in public this wasn't a problem, but with elaborate use of schemae it's pretty scary (for me). ____________________________________________________________________________________ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ