Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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


pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group