X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 3BAEC329E25 for ; Fri, 24 Sep 2004 22:37:36 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 31966-07 for ; Fri, 24 Sep 2004 21:37:32 +0000 (GMT) Received: from hosting.commandprompt.com (128.commandprompt.com [207.173.200.128]) by svr1.postgresql.org (Postfix) with ESMTP id 632B3329C67 for ; Fri, 24 Sep 2004 22:37:33 +0100 (BST) Received: from [192.168.1.20] (clbb-248.saw.net [64.146.135.248]) (authenticated) by hosting.commandprompt.com (8.11.6/8.11.6) with ESMTP id i8OLbWk05162; Fri, 24 Sep 2004 14:37:32 -0700 Message-ID: <41549305.1070808@commandprompt.com> Date: Fri, 24 Sep 2004 14:35:01 -0700 From: "Joshua D. Drake" Organization: Command Prompt, Inc. User-Agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Hemapriya Cc: pgsql-admin@postgresql.org Subject: Re: View Different Schemas References: <20040924213158.79009.qmail@web21321.mail.yahoo.com> In-Reply-To: <20040924213158.79009.qmail@web21321.mail.yahoo.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/235 X-Sequence-Number: 14938 Hemapriya wrote: >Hi, > >Can anyone tell me how to view the different schemas >in a database. I have created a schema and some tables >in it. Also I have altered the search_path to add the >new schema.. but still /dt doesn't give me the new >schema and its tables. > > you can do set search_path=schema; \d >Any help? > >Thanks >Priya > > > > >__________________________________ >Do you Yahoo!? >New and Improved Yahoo! Mail - 100MB free storage! >http://promotions.yahoo.com/new_mail > >---------------------------(end of broadcast)--------------------------- >TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > > -- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC Postgresql support, programming shared hosting and dedicated hosting. +1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com PostgreSQL Replicator -- production quality replication for PostgreSQL