On 08/22/12 15:19, Gauthier, Dave wrote: > > I know a view can be used to alias one of them. It can alias all of them: create view xyz as select *, last_name as lname, last_name as surname from mytable; (not the nicest version but functional) HTH. Bosco. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general