Обсуждение: Where are aliases stored?

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

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

Thanks, but this does not meet my needs.

Is there not a way to query the pg_ catalog views and get a listing of views with columns (by alias name)?

i.e.

create view asdf as
select xyz as test1 from bogus_table;

I need a query that says:
view|column|alias
asdf|xyz|test1

Thanks,

Chris

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/