Thread: FW: Sorting and filtering in PgAdmin
Hi, I am a big fan of PgAdmin and just joined the list. There is one thing, however, that could really be improved. I think the sorting and filtering of columns in the table view is less than intuitive. Could the columns be sorted by double clicking on the columns? I know that currently this action auto-fits the column width but that could be limited to double clicking on the column border. Another option would be providing an arrow icon in the column header to control sorting and filtering (as the V.S. .Net DataGrid does). If the wxWidgets library does not support this, as a minimum it would be great if the data sorting and filtering tabs in the 'View Data Options' form had a list of drag-and-drop columns. Currently I have to change the sort order by clicking remove on each existing column, activating the Available Columns list, selecting a new column and then choosing the sort order. What do others think?? Nic Thiele
Hi Nic,
I am with you. I think it should be changed too. The automatic sort on oid is useless anyway.. better sort on the first ' normal' column by default anyay.
Cheers,
Bastiaan
On Tue, 2006-02-07 at 10:19 +1030, Nicholas Thiele wrote:
I am with you. I think it should be changed too. The automatic sort on oid is useless anyway.. better sort on the first ' normal' column by default anyay.
Cheers,
Bastiaan
On Tue, 2006-02-07 at 10:19 +1030, Nicholas Thiele wrote:
Hi, I am a big fan of PgAdmin and just joined the list. There is one thing, however, that could really be improved. I think the sorting and filtering of columns in the table view is less than intuitive. Could the columns be sorted by double clicking on the columns? I know that currently this action auto-fits the column width but that could be limited to double clicking on the column border. Another option would be providing an arrow icon in the column header to control sorting and filtering (as the V.S. .Net DataGrid does). If the wxWidgets library does not support this, as a minimum it would be great if the data sorting and filtering tabs in the 'View Data Options' form had a list of drag-and-drop columns. Currently I have to change the sort order by clicking remove on each existing column, activating the Available Columns list, selecting a new column and then choosing the sort order. What do others think?? Nic Thiele ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
I agree completely, but would like to be able to define a sorting order and make it the default any time I view records in a table. This would save loads of time. -- View this message in context: http://postgresql.1045698.n5.nabble.com/FW-Sorting-and-filtering-in-PgAdmin-tp2156945p3278393.html Sent from the PostgreSQL - pgadmin hackers mailing list archive at Nabble.com.
Le 24/11/2010 14:31, lbates35406 a écrit : > > I agree completely, but would like to be able to define a sorting order and > make it the default any time I view records in a table. This would save > loads of time. If I try to list the different issues here: * sort with double click on a column * auto-fit with double click on a column border * arrow icon on the sorted column header (might get fun with sorting with more than one column) BTW, neither of these are supported by wxWidgets 2.8 AFAIK. There is no automatic sort on OID (there is no OID since quite some time). Actually, there is no automatic sort if the user doesn't specify one. And it'll stay that way. I don't get the maintain last sort. It'll probably work if you keep opening the same table, but if you open another one, there's good chance the sorted column won't exist. I don't see how we can do that in a good way. -- Guillaume http://www.postgresql.fr http://dalibo.com
Le 26/11/2010 04:18, Larry Bates a écrit : > when I filter a table, the results come back sorted on the first column > (normally some sort of id). I can sort it other ways under Data Sorting tab. > What I'm saying is that when I define a new sort order it would be nice to be > able to click on a button to make this the "default" sort order for the table > whenever I look at the rows contained (see attached mock up of dialog). A > default sort order could be saved for each table. After a while, you would get > all of them sorted in the way that you wish to look at them MOST of the time. > > Since this is something that I encounter over and over, I thought I would make > the suggestion because it is probably affecting others as well. > Which means you want to keep a specific order for each table. Which is not that simple. It means we need to record "somewhere" that you want that the table tablename in schema schemaname in database databasename will be sorted this way. This could make pgAdmin's config file way bigger than it already is. Anyway, it's probably interesting to have. I still need to think about the UI. BTW, keep the list in your answer. -- Guillaume http://www.postgresql.fr http://dalibo.com