Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 2478F2E005C for ; Mon, 28 Apr 2008 14:01:44 -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 95330-03 for ; Mon, 28 Apr 2008 14:01:39 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from web54302.mail.re2.yahoo.com (web54302.mail.re2.yahoo.com [206.190.49.112]) by developer.postgresql.org (Postfix) with SMTP id 1F1372E004A for ; Mon, 28 Apr 2008 14:01:39 -0300 (ADT) Received: (qmail 74940 invoked by uid 60001); 28 Apr 2008 17:01:38 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=sjfRS0y7UvKF3sEhnfoPtgsLGGHJCcY/gD0aT8QO1latMxGBFQ9aLdJHXik50r5Pi5Fjr/KuXLVOW2K+4SnU3KLctRNsaIMedClZWXx2LQIfSTRatVDDdre/JUAcYG9w5VzYkixBerh36ttvSGAM7ELvalGFhlvf7vtMcpISjmc=; X-YMail-OSG: sdG0_u0VM1nGGrHPsfcLAKem9TxBkxdspsLWo.f0y5NwPi.f71_v2ameNMihE32QNXiwcJpjVgQ3WxUwwM5R4vjttdCk4mABh1QPr6AmzzATN0mSzgnCbfbsYw-- Received: from [69.227.19.53] by web54302.mail.re2.yahoo.com via HTTP; Mon, 28 Apr 2008 10:01:37 PDT Date: Mon, 28 Apr 2008 10:01:37 -0700 (PDT) From: chester c young Subject: Re: psql: no schema info To: sql pgsql In-Reply-To: <48157D01.5050405@archonet.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <38117.57623.qm@web54302.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/213 X-Sequence-Number: 30752 > > # \dt table1 -> does not show which schema info. was wrong on this - \dt shows schema for relations _not_ in the search path. my new good practice is to keep search_path = PUBLIC so all schema info is displayed always all the time invariably. ____________________________________________________________________________________ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ