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 r...@iol.ie Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------ -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
