From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
---|---|
To: | Michael Fraley <fraley(at)usfca(dot)edu> |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: default data sort |
Date: | 2009-06-21 18:57:50 |
Message-ID: | 4A3E82AE.2010908@iol.ie |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
On 21/06/2009 18:57, Michael Fraley wrote:
> How can I change the default data sort for a table? When I view the data
> in the selected table, it always opens a spreadsheet view sorted by the
> primary key. In this case, the primary key is a one-up number and a more
> useful sort is the name column. How can I have it default to sort by
> name rather than primary key?
When you open the data view window, go to Tools -> Sort/Filter, and
select the column by which you want to sort.
Also, you could open a query window and do
select * from my_table order by desired_sort_column;
Ray.
------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2009-06-22 07:45:21 | Re: help on plpgsqldebugger |
Previous Message | Michael Fraley | 2009-06-21 18:26:58 | default data sort |