Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 8B2159FB952 for ; Thu, 12 Apr 2007 12:35:30 -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 07580-07 for ; Thu, 12 Apr 2007 12:35:29 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from gauss.credativ.com (ipx11302.ipxserver.de [212.112.227.254]) by postgresql.org (Postfix) with ESMTP id 001619FA4C1 for ; Thu, 12 Apr 2007 12:35:29 -0300 (ADT) Received: from hawking.credativ.lan (unknown [87.139.82.80]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by gauss.credativ.com (Postfix) with ESMTP id 3C526D78E6; Thu, 12 Apr 2007 17:35:27 +0200 (CEST) From: Peter Eisentraut To: pgsql-admin@postgresql.org Subject: Re: Where are aliases stored? Date: Thu, 12 Apr 2007 17:35:15 +0200 User-Agent: KMail/1.9.5 Cc: "Chris Hoover" , "Robert Treat" References: <1d219a6f0704111314v5fb773fdoc6bccb67b5289e31@mail.gmail.com> <200704112104.55584.xzilla@users.sourceforge.net> <1d219a6f0704120746ld395edfk624f5f5d2cd5e0cd@mail.gmail.com> In-Reply-To: <1d219a6f0704120746ld395edfk624f5f5d2cd5e0cd@mail.gmail.com> MIME-Version: 1.0 Content-Disposition: inline Message-Id: <200704121735.16082.peter_e@gmx.net> Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/123 X-Sequence-Number: 25187 Am Donnerstag, 12. April 2007 16:46 schrieb Chris Hoover: > Is there not a way to query the pg_ catalog views and get a listing of > views with columns (by alias name)? The column names (what you call alias names) are in pg_attribute, the views are in pg_class. -- Peter Eisentraut http://developer.postgresql.org/~petere/