X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 973A6D7D66 for ; Mon, 17 Oct 2005 18:22:18 -0300 (ADT) 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 14659-05 for ; Mon, 17 Oct 2005 21:22:14 +0000 (GMT) Received: from hub.org (hub.org [200.46.204.220]) by svr1.postgresql.org (Postfix) with ESMTP id 767ACD7D33 for ; Mon, 17 Oct 2005 18:22:15 -0300 (ADT) Received: from localhost (av.hub.org [200.46.204.144]) by hub.org (Postfix) with ESMTP id B1DDE64BB4F for ; Mon, 17 Oct 2005 18:22:18 -0300 (ADT) Received: from hub.org ([200.46.204.220]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 16833-02 for ; Mon, 17 Oct 2005 21:22:10 +0000 (GMT) Received: from ganymede.hub.org (blk-222-82-85.eastlink.ca [24.222.82.85]) by hub.org (Postfix) with ESMTP id 9213764BB3E for ; Mon, 17 Oct 2005 18:22:14 -0300 (ADT) Received: by ganymede.hub.org (Postfix, from userid 1000) id AB84039712; Mon, 17 Oct 2005 18:22:16 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by ganymede.hub.org (Postfix) with ESMTP id AABEF36CD1 for ; Mon, 17 Oct 2005 18:22:16 -0300 (ADT) X-Return-Path: X-Received: from ganymede.hub.org ([unix socket]) by ganymede.hub.org (Cyrus v2.2.12) with LMTPA; Mon, 17 Oct 2005 02:46:22 -0300 X-Sieve: CMU Sieve 2.2 X-Received: from localhost (localhost [127.0.0.1]) by ganymede.hub.org (Postfix) with ESMTP id 64F193AA99 for ; Mon, 17 Oct 2005 02:46:22 -0300 (ADT) X-Received: from mail.postgresql.org [200.46.204.71] by localhost with IMAP (fetchmail-6.2.5.2) for scrappy@localhost (single-drop); Mon, 17 Oct 2005 02:46:22 -0300 (ADT) X-Received: from svr1.postgresql.org ([unix socket]) by svr1.postgresql.org (Cyrus v2.2.12) with LMTPA; Mon, 17 Oct 2005 02:45:36 -0300 X-Sieve: CMU Sieve 2.2 X-Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 2E2B7D7986 for ; Mon, 17 Oct 2005 02:45:36 -0300 (ADT) X-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 50670-10 for ; Mon, 17 Oct 2005 05:45:34 +0000 (GMT) X-Received: from qproxy.gmail.com (qproxy.gmail.com [72.14.204.207]) by svr1.postgresql.org (Postfix) with ESMTP id 5D2D0DA74F for ; Mon, 17 Oct 2005 02:45:34 -0300 (ADT) X-Received: by qproxy.gmail.com with SMTP id u24so138647qbh for ; Sun, 16 Oct 2005 22:45:34 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=bE45HKHkLFLjVgg0W1z4Fz/0qdv/zbRd4RdmYebJy+kLGK/DZjZ8nDIg9teEhNVjsWrD3cBe+Qq6URIGGlrqYM/KYPQlzboNWHkBp1TjgZx2TBTGNM/JtLTufe8a3gTdKDFawgKMclhlBJI/pQMQCqmPjzzw6yfVhNxT9EYqULE= X-Received: by 10.64.152.5 with SMTP id z5mr1682227qbd; Sun, 16 Oct 2005 22:45:34 -0700 (PDT) X-Received: by 10.64.156.9 with HTTP; Sun, 16 Oct 2005 22:45:34 -0700 (PDT) Message-ID: Date: Mon, 17 Oct 2005 11:15:34 +0530 From: Rajesh Kumar Mallah To: Colton A Smith Subject: Re: query for view code Cc: pgsql_admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: X-Virus-Scanned: by amavisd-new at hub.org ReSent-Date: Mon, 17 Oct 2005 18:22:12 -0300 (ADT) Resent-From: "Marc G. Fournier" Resent-To: pgsql-admin@postgresql.org ReSent-Subject: Re: query for view code ReSent-Message-ID: <20051017182212.N995@ganymede.hub.org> X-Virus-Scanned: by amavisd-new at hub.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.946 required=5 tests=[AWL=0.896, FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200510/215 X-Sequence-Number: 19287 Yes connect using psql -E database> \d viewname observe the query that are used to produce the view defination Regds Rajesh Kumar mallah. On 10/13/05, Colton A Smith wrote: > Hi: > > Can I query the database for the code for a particular view? > > Thanks for your help! > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings >