Postgres Pro
Downloads
Home   >   mailing lists

Re: Where are aliases stored? - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: Where are aliases stored?
Date
Msg-id 200704121735.16082.peter_e@gmx.net
Whole thread Raw
In response to Re: Where are aliases stored?  ("Chris Hoover" <revoohc@gmail.com>)
List pgsql-admin
Tree view 
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/

pgsql-admin by date:

Previous
From: "Chris Hoover"
Date:
Subject: Re: Where are aliases stored?
Next
From: Karthikeyan Sundaram
Date:
Subject: question on plpgsql block