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.– kgrittnApr 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.– newenglanderApr 16, 2012 at 11:43
1 Answer
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.– pritaeasApr 16, 2012 at 13:14
-
You cannot specify an ordering in a view without using some trickery. Jun 11, 2012 at 15:15
-
1