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, 2012 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. Apr 16, 2012 at 11:43

1 Answer 1


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

  • Yes, that would be an alternative, if no other client offers what I'm looking for. Apr 16, 2012 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, 2012 at 13:14
  • You cannot specify an ordering in a view without using some trickery. Jun 11, 2012 at 15:15
  • 1
    Can you explain why an ORDER BY would not work?
    – pritaeas
    Jun 13, 2012 at 7:22

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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