Thread: Pgadmin 4 view and sort table
Hi,
Perhaps I am jumping the gun here, as the software is recently released, but I am having trouble figuring out some basic operations that I could do using PGAdmin 3.
1. Open a table in its own window. In PGAdmin 3, opening a table opened its own window that was independent of the main system tree. This allowed for arranging multiple tables across screens. Now, all windows may float, but they are constrained within the application window. Is this by design, or am I missing something? It makes it infinitely more difficult to use when everything is constrained to a single window.
2. When you view the data in a table, it does not seem possible to sort the table. Opening a table to view all records creates a "Query-1" tab, which has a basic Select * by query, with order by the primary key. This is all greyed out and unable to be modified. How do you resort a table?
These are just basic questions I have right now. I've tried to look at the documentation, but it doesn't even address these items, as they seem to be considered basic usage.
For background, I am running pgAdmin 4 on a Windows 7 machine, installed from the downloaded installer.
Any assistance would be greatly appreciated.
Thanks,
Russell
Bumping this to the top and hoping someone can weigh in for me.
Thanks,
Russell
On 2016-10-19 17:54, Russell Mercer wrote:
Hi,
Perhaps I am jumping the gun here, as the software is recently released, but I am having trouble figuring out some basic operations that I could do using PGAdmin 3.
1. Open a table in its own window. In PGAdmin 3, opening a table opened its own window that was independent of the main system tree. This allowed for arranging multiple tables across screens. Now, all windows may float, but they are constrained within the application window. Is this by design, or am I missing something? It makes it infinitely more difficult to use when everything is constrained to a single window.
2. When you view the data in a table, it does not seem possible to sort the table. Opening a table to view all records creates a "Query-1" tab, which has a basic Select * by query, with order by the primary key. This is all greyed out and unable to be modified. How do you resort a table?
These are just basic questions I have right now. I've tried to look at the documentation, but it doesn't even address these items, as they seem to be considered basic usage.
For background, I am running pgAdmin 4 on a Windows 7 machine, installed from the downloaded installer.
Any assistance would be greatly appreciated.
Thanks,
Russell
Russell, I'm responding as a fellow user. >> Perhaps I am jumping the gun here, as the software is recently >> released, but I am having trouble figuring out some basic operations >> that I could do using PGAdmin 3. >> >> 1. Open a table in its own window. In PGAdmin 3, opening a table >> opened its own window that was independent of the main system tree. >> This allowed for arranging multiple tables across screens. Now, all >> windows may float, but they are constrained within the application >> window. Is this by design, or am I missing something? It makes it >> infinitely more difficult to use when everything is constrained to a >> single window. This is definitely a limitation, I expect largely due to the convertion to a browser-based primary application version. Note that I'm using the webserver, so I don't know if there's a way around this in the desktop app. >> >> 2. When you view the data in a table, it does not seem possible to >> sort the table. Opening a table to view all records creates a >> "Query-1" tab, which has a basic Select * by query, with order by the >> primary key. This is all greyed out and unable to be modified. How >> do you resort a table? At this point? Add "ORDER BY column" to the query. -- -- Josh Berkus Red Hat OSAS (any opinions are my own)
On Mon, Oct 24, 2016 at 5:37 AM, Josh Berkus <josh@agliodbs.com> wrote: > Russell, > > I'm responding as a fellow user. > > >>> Perhaps I am jumping the gun here, as the software is recently >>> released, but I am having trouble figuring out some basic operations >>> that I could do using PGAdmin 3. >>> >>> 1. Open a table in its own window. In PGAdmin 3, opening a table >>> opened its own window that was independent of the main system tree. >>> This allowed for arranging multiple tables across screens. Now, all >>> windows may float, but they are constrained within the application >>> window. Is this by design, or am I missing something? It makes it >>> infinitely more difficult to use when everything is constrained to a >>> single window. > > This is definitely a limitation, I expect largely due to the convertion > to a browser-based primary application version. Note that I'm using the > webserver, so I don't know if there's a way around this in the desktop app. Right - because it's a web app, it's constrained to the browser (which includes the desktop runtime). Some panel types are largely self-contained though (e.g. the query tool and debugger), so we have a TODO to allow them to be opened in new browser windows or tabs - this is noted in the feature request here: https://redmine.postgresql.org/issues/1344 >>> 2. When you view the data in a table, it does not seem possible to >>> sort the table. Opening a table to view all records creates a >>> "Query-1" tab, which has a basic Select * by query, with order by the >>> primary key. This is all greyed out and unable to be modified. How >>> do you resort a table? > > At this point? Add "ORDER BY column" to the query. You can't currently edit the query when in View Data mode (because we don't yet have enough smarts to determine whether the output of an arbitrary query is updatable or not). It looks like we lost the ability to sort though, I suspect when we moved to using SlickGrid instead of BackGrid. Currently, we always sort by the primary key I believe, but you do also have filtering options that may help find what you're looking for. Missing feature logged here: https://redmine.postgresql.org/issues/1894 -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company