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