Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id B92889FB3A4 for ; Wed, 11 Apr 2007 17:14:21 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 62234-08 for ; Wed, 11 Apr 2007 17:14:11 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.243]) by postgresql.org (Postfix) with ESMTP id 314939FB365 for ; Wed, 11 Apr 2007 17:14:14 -0300 (ADT) Received: by an-out-0708.google.com with SMTP id c24so351227ana for ; Wed, 11 Apr 2007 13:14:13 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; b=pq8d6EgMQevYF3oskrFwB/suFE9j4jN30nUdlrrCjQ+uLl8+xqnfluTZWRNu6qUSqc2Iirp7QIPIP1rGr5d9Srsxk2SYxhqcLq9fjgBL8MwawcfTrMeDSWHPOFt2IY/Goqi8Mk8fKzt/+xx3Bg2I3rsMcnpw6rUFy10npYo/v90= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type; b=id+pJ9DNeqXspo7N/zCcAXUfAzMAs0vWwSK9QXBCdbX9hIzt61Ia4ePC5TeaMbtkJbKEchnHSbveHHSqf2wdvx7e4cEI2PNkclaZt484bx7QMvi9aXp4EvMvY8gd7lQOarbfJOw0owQQB19LYFpICclGHYrbfgpkzEZg1zbel7Y= Received: by 10.100.154.13 with SMTP id b13mr783285ane.1176322452897; Wed, 11 Apr 2007 13:14:12 -0700 (PDT) Received: by 10.100.165.19 with HTTP; Wed, 11 Apr 2007 13:14:12 -0700 (PDT) Message-ID: <1d219a6f0704111314v5fb773fdoc6bccb67b5289e31@mail.gmail.com> Date: Wed, 11 Apr 2007 16:14:12 -0400 From: "Chris Hoover" To: "pgsql-admin@postgresql.org" Subject: Where are aliases stored? MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_11690_10604395.1176322452750" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/101 X-Sequence-Number: 25165 ------=_Part_11690_10604395.1176322452750 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline 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. Thanks, Chris ------=_Part_11690_10604395.1176322452750 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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.

Thanks,

Chris
------=_Part_11690_10604395.1176322452750--