postgresql7.1 select usename as name1, usename as name2 from pg_user order by usename SELECT groname as group1, groname as group2 FROM pg_group ORDER BY groname