Thread: Sorting questions and an SSL question
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. In any event, I hoping this is something that I'm either missing or is in the works for a future release. Also, on the Slackware 9 client, the SSL drop down box is empty. Is there something I have to do to get the options to appear? Thanks in advance... -- Keith C. Perry Director of Networks & Applications VCSN, Inc. http://vcsn.com ____________________________________ This email account is being host by: VCSN, Inc : http://vcsn.com
Hi Keith, > -----Original Message----- > From: Network Administrator [mailto:netadmin@vcsn.com] > Sent: 01 October 2003 15:47 > To: pgadmin-support@postgresql.org > Subject: [pgadmin-support] Sorting questions and an SSL question > > > 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. Currently you cannot unfortunately. This is something I hope to implement, but is not nearly as straightforward with wxWindows as it was in Visual Basic. > 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. :-) I haven't used pgAccess since about 1997, so cannot comment on it's capabilities. Entering of sort/filter parameters does seem useful though. I'll take a look at that as well. > > In any event, I hoping this is something that I'm either > missing or is in the works for a future release. > > Also, on the Slackware 9 client, the SSL drop down box is > empty. Is there something I have to do to get the options to appear? So it is :-( That's odd. I'll check that out as well (you shouldn't have to do anything). Regards, Dave.
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
Quoting Dave Page <dpage@vale-housing.co.uk>: > Hi Keith, > > > -----Original Message----- > > From: Network Administrator [mailto:netadmin@vcsn.com] > > Sent: 01 October 2003 15:47 > > To: pgadmin-support@postgresql.org > > Subject: [pgadmin-support] Sorting questions and an SSL question > > > > > > 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. > > Currently you cannot unfortunately. This is something I hope to > implement, but is not nearly as straightforward with wxWindows as it was > in Visual Basic. > > > 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. > > :-) I haven't used pgAccess since about 1997, so cannot comment on it's > capabilities. Entering of sort/filter parameters does seem useful > though. I'll take a look at that as well. > > > > > In any event, I hoping this is something that I'm either > > missing or is in the works for a future release. > > > > Also, on the Slackware 9 client, the SSL drop down box is > > empty. Is there something I have to do to get the options to appear? > > So it is :-( That's odd. I'll check that out as well (you shouldn't have > to do anything). > > Regards, Dave. > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend > Ok, thanks Dave. One of the networks I manage needs HIPAA compliancies and althought those would be Windows clients (where the SSL appears to be available and would meet any requirements). It would be good for people like myself who would also be connecting from the Slackware Linux side of things. As far as the sorting, I hope wxWindows isn't too much of a headache :) -- Keith C. Perry Director of Networks & Applications VCSN, Inc. http://vcsn.com ____________________________________ This email account is being host by: VCSN, Inc : http://vcsn.com
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
> -----Original Message----- > From: Network Administrator [mailto:netadmin@vcsn.com] > Sent: 01 October 2003 16:35 > To: Dave Page > Cc: pgadmin-support@postgresql.org > Subject: Re: [pgadmin-support] Sorting questions and an SSL question > > > > Ok, thanks Dave. One of the networks I manage needs HIPAA > compliancies and althought those would be Windows clients > (where the SSL appears to be available and would meet any > requirements). It would be good for people like myself who > would also be connecting from the Slackware Linux side of things. I'm working on it now! > As far as the sorting, I hope wxWindows isn't too much of a > headache :) No it's not :-). In pgAdmin II we retrieved the entire recordset and sorted using methods provided by the Microsoft Listview control. In wx there are no such methods, so we would have to write them ourselves. This is no problem in itself, apart from the fact that the grid can handle many times the amount of data of pga2, partly because we don't download it all at once. Regards, Dave.