Re: Where are aliases stored?

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Cc: "Chris Hoover" <revoohc(at)gmail(dot)com>
Subject: Re: Where are aliases stored?
Date: 2007-04-12 01:04:55
Message-ID: 200704112104.55584.xzilla@users.sourceforge.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Robert Treat 2007-04-12 01:12:02 Re: Restoring single database from an export dump of a cluster
Previous Message Karthikeyan Sundaram 2007-04-11 23:29:45 Re: [SQL] Urgent help in bit_string data type