Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id C88BD9FA468 for ; Wed, 11 Apr 2007 22:05:43 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 33760-10 for ; Wed, 11 Apr 2007 22:05:35 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from vms040pub.verizon.net (vms040pub.verizon.net [206.46.252.40]) by postgresql.org (Postfix) with ESMTP id 00ED59FA271 for ; Wed, 11 Apr 2007 22:05:40 -0300 (ADT) Received: from new-host.home ([71.166.59.121]) by vms040.mailsrvcs.net (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) with ESMTPA id <0JGD003171OUQJM2@vms040.mailsrvcs.net> for pgsql-admin@postgresql.org; Wed, 11 Apr 2007 20:05:19 -0500 (CDT) Date: Wed, 11 Apr 2007 21:04:55 -0400 From: Robert Treat Subject: Re: Where are aliases stored? In-reply-to: <1d219a6f0704111314v5fb773fdoc6bccb67b5289e31@mail.gmail.com> To: pgsql-admin@postgresql.org Cc: "Chris Hoover" Message-id: <200704112104.55584.xzilla@users.sourceforge.net> MIME-version: 1.0 Content-type: text/plain; charset=iso-8859-15 Content-transfer-encoding: 7bit Content-disposition: inline References: <1d219a6f0704111314v5fb773fdoc6bccb67b5289e31@mail.gmail.com> User-Agent: KMail/1.9.1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/108 X-Sequence-Number: 25172 On Wednesday 11 April 2007 16:14, Chris Hoover wrote: > I'm trying to pull a listing of views with the columns and column aliases. > However, I must be blind, and can't find what system view has the alias for > the columns of the view. Would someone please enlighten me. > See pg_catalog.pg_views.definition. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL