SEO

I really like the new features in the EditGrid, but I have a few feature
requests. The first is just a convenience function, really. It's a very
common idiom on Win32 to click a column header and get a sort on
that column. Similar functionality would be nice in pgAdmin. I realize
that it's not as powerful as the multi-column select that is available,
but it would be a nice complement to it. The other feature is much
more important to me. I often want to view records in very large
tables, but I don't want to wait a long time for the entire table to
load. I usually don't want to see the entire table anyway. What
would be nice is if the EditGrid could detect that a table will show
more than 1000 rows, and automatically set a filter that shows the
first 1000 rows. Then, if you really want to see the whole table, you
could go and erase the filter. This way, I can look at a large table in
a reasonable amount of time without loading every record.

The main reason I like to use the EditGrid to view data is because it
shows empty strings as '', while the SQL viewer does not. With the
SQL viewer I cannot see if a blank field is null or empty. So alternatively,
if the SQL viewer displayed empty strings as '', that would work for me.

__
David B. Held
Software Engineer/Array Services Group
200 14th Ave. East, Sartell, MN 56377
320.534.3637 320.253.7800 800.752.8129

Dave Held wrote:
> I really like the new features in the EditGrid, but I have a few feature
> requests. The first is just a convenience function, really. It's a very
> common idiom on Win32 to click a column header and get a sort on
> that column. Similar functionality would be nice in pgAdmin. I realize
> that it's not as powerful as the multi-column select that is available,
> but it would be a nice complement to it.

Since the ordering is done on the server side, we'll probably stay with
the current solution.

> The other feature is much
> more important to me. I often want to view records in very large
> tables, but I don't want to wait a long time for the entire table to
> load. I usually don't want to see the entire table anyway.

Use the "View filtered data" instead of "View data". We get to know too
late about the size of the result set to have it conveniently cut down.

Regards,
Andreas

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)