Re: Sorting questions and an SSL question

Quoting Andreas Pflug <pgadmin@pse-consulting.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