On Fri, Nov 13, 2009 at 6:33 AM, Gauthier, Dave <dave.gauthier@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general