pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Peter Eisentraut <peter_e@gmx.net>
To: pgsql-admin@postgresql.org
Cc: Chris Hoover <revoohc@gmail.com>
Cc: Robert Treat <xzilla@users.sourceforge.net>
Subject: Re: Where are aliases stored?
Date: Thu, 12 Apr 2007 17:35:15 +0200
Message-ID: <200704121735.16082.peter_e@gmx.net> (raw)
In-Reply-To: <1d219a6f0704120746ld395edfk624f5f5d2cd5e0cd@mail.gmail.com>
References: <1d219a6f0704111314v5fb773fdoc6bccb67b5289e31@mail.gmail.com>
	<200704112104.55584.xzilla@users.sourceforge.net>
	<1d219a6f0704120746ld395edfk624f5f5d2cd5e0cd@mail.gmail.com>

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/



view thread (4+ messages)

Message-ID: <200704121735.16082.peter_e@gmx.net>
Permalink:  ../200704121735.16082.peter_e@gmx.net/
Also on:    postgresql.org/message-id/200704121735.16082.peter_e@gmx.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: peter_e@gmx.net, revoohc@gmail.com, xzilla@users.sourceforge.net
  Subject: Re: Where are aliases stored?
  In-Reply-To: <200704121735.16082.peter_e@gmx.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox