On Wed, Nov 8, 2017 at 9:41 AM, Gene Thomas <g...@nlc.co.nz> wrote: > Hello, > > Firstly, thanks for pgadmin 4, I have found it useful. 1. However, > I would really appreciate, if when displaying query results, the columns > were resized to fit the values. I recently spent quite some time being > misled because the leading digits in some numbers were cut off because the > column was not wide enough, and there was no indication that the start of > the number was truncated. > The grid layout is kept to fit the result set on most of the screen resolutions and we are doing this intentionally as pgAdmin4 uses on-demand logic for data retrieval from database server, so we can't predict the size for next columns in advance, as the data in a column may vary. Just consider the simple scenario where column-x in Row-1 has text of length 10 characters and in Row- 2
it has text of length 10 000 characters . > 2. Also it would be useful if one could configure the display so text > values are show in ‘quotes’, I have to deal with padded values so it would > be really useful to see when there is padding. The display of null as > [null] is much appreciated. > The feature you are requesting will mislead other users, if the actual result will starts with quotes then user might face the problems in inserting/updating the data. > 3. Also being able to display the query result transposed would be useful, > e.g. column headings down the side and the rows displayed in columns. > Could you please provide more details on this, what's the specific benefit we (as a pgAdmin4 user) may get from this feature? > 4. Also being able to display table definitions, i.e. \d table_name in > psql would be useful, one has to quickly check table definitions some > times. > \d is feature of psql, if you want to see the database object definition quickly you can simply select the respective object in browser tree and select the SQL tab. > > > Yours Sincerely, > > > > Gene Thomas. > -- Regards, Murtuza Zabuawala EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
