Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Is there a Postgres client (for Windows) that can save customized sorting when viewing tables? Obviously I could write and save a query for this, but perhaps there's a client that can do this for me. I know MS Access can do this (via ODBC), but I'd prefer a better client.

share|improve this question
    
It's not very clear what you're looking for. Maybe pgadmin3? If not, please explain a bit more. –  kgrittn Apr 16 '12 at 10:13
    
Sure, I use pgadmin3, and if I open a table and then sort using certain columns, the sorting is gone when I close the table. I'm looking for a client that can save this information so that the sorting remains when I reopen the table. –  newenglander Apr 16 '12 at 11:43
add comment

1 Answer

Why not create a VIEW? The upside is that it is client independent.

share|improve this answer
    
Yes, that would be an alternative, if no other client offers what I'm looking for. –  newenglander Apr 16 '12 at 12:53
    
I use Navicat which makes sorting real easy, but I don't think it will let you save the current sorts/filters. –  pritaeas Apr 16 '12 at 13:14
    
You cannot specify an ordering in a view without using some trickery. –  Nick Chammas Jun 11 '12 at 15:15
1  
Can you explain why an ORDER BY would not work? –  pritaeas Jun 13 '12 at 7:22
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.