Re: Sorting questions and an SSL question

Quoting Andreas Pflug <pgadmin(at)pse-consulting(dot)de>:

> 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
>

Ahhh, ok so in the meantime what I'll do is make a query and include the oids.
Then I can find and edit table data that way.

--
Keith C. Perry
Director of Networks & Applications
VCSN, Inc.
http://vcsn.com

____________________________________
This email account is being host by:
VCSN, Inc : http://vcsn.com