On Fri, Nov 13, 2009 at 6:33 AM, Gauthier, Dave <dave.gauthier@intel.com> wrote:
> Does PG support the notion of a colum alias?
No, the closest thing would be alias names from a VIEW.
> Is there a way to assign 2 different names for the same column to support a
> situation like above?
No.
> I was thinking that a view might do this, but is not a direct table query.
> It’s also not editable.
you can make your view editable fairly easily by implementing rules.
However, there is a limitation with rules in the case of multiple
record modifications.
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug