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.

  • 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

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

|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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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