Network Administrator wrote:
>Greetings everyone,
>
>First of all, thank you for pgAdmin III. Its a very nice tool and I used it in
>on Winblowz 2000 and I also installed it on one of my Linux laptops (Slackware9
>Package).
>
>I've got serveral questions that concern me in moving forward recommending this
>tool be used. I hoping the answer evade be because of my own ignorance.
>
>One of the things I remember doing in pgAdmin II is that I could view the table
>data and then (I think click) a column so that the data would be sorted.
>However now it seems like that functional is gone altogether. So the question
>is how does one sort the data that is being viewed. Ideally, I was hoping that
>pgAdmin III would go to the next step of being able to view data in the way that
>the old version of pgAccess did. That is to say, the user could entry multiple
>sort parameters (i.e. an order by clause). Futher more a filter (i.e. where
>clause) would be nice too. I still use pgAcess on the *nix side because I can
>do at least the sorting piece in their current version (though, the orginal
>version had exactly what stated above). pgAccess hasn't had a release in quite
>awhile and although I haven't contacted the developers there, I've been leaning
>towards using pgAdmin as the single tool I use.
>
We'll probably add some features to the EditGrid, and user supplied
sorting is one of that, better input checking is another.
Sorting works very different from pgAdmin2, because we do *not* retrieve
all data and sort in memory, instead sorting is done on the server.
Currently, the ORDER BY clause is tied to the primary key (or OID),
reordering will need a requery.
Regards,
Andreas