Postgres Pro
Downloads
Home   >   mailing lists

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

From Robert Treat
Subject Re: Where are aliases stored?
Date
Msg-id 200704112104.55584.xzilla@users.sourceforge.net
Whole thread Raw
In response to Where are aliases stored?  ("Chris Hoover" <revoohc@gmail.com>)
Responses Re: Where are aliases stored?
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Karthikeyan Sundaram
Date:
Subject: Re: [SQL] Urgent help in bit_string data type
Next
From: Robert Treat
Date:
Subject: Re: Restoring single database from an export dump of a cluster