Thread: In PgAdmin, how can I see all of a long text field?

In PgAdmin, how can I see all of a long text field?

From
"Rob Richardson"
Date:
My stack_requests table has a field named inventory_filter of type text.  The size of that field is not specified.  It can contain a string several hundred characters long.  Using PgAdmin, how can I see the entire inventory_filter field for a given record no matter how long it is?  A query like "select * from inventory_record where key = 'some_key' " gives me a grid, and no matter how big I make the inventory_filter column, I can't see the whole thing.  Event if I limit my query to the inventory_record column, the display is limited to the width of my monitor, which is often not enough.  How can I use PgAdmin to see the entire field?
 
Thank you.
 
RobR
 

Re: In PgAdmin, how can I see all of a long text field?

From
Thom Brown
Date:
On 8 November 2010 16:35, Rob Richardson <Rob.Richardson@rad-con.com> wrote:
My stack_requests table has a field named inventory_filter of type text.  The size of that field is not specified.  It can contain a string several hundred characters long.  Using PgAdmin, how can I see the entire inventory_filter field for a given record no matter how long it is?  A query like "select * from inventory_record where key = 'some_key' " gives me a grid, and no matter how big I make the inventory_filter column, I can't see the whole thing.  Event if I limit my query to the inventory_record column, the display is limited to the width of my monitor, which is often not enough.  How can I use PgAdmin to see the entire field?

In PgAdmin's config, you can change how much is returned:

File > Options > Query Tool > Max. characters per column

--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935

Re: In PgAdmin, how can I see all of a long text field?

From
"Rob Richardson"
Date:
Thank you.  That got me what I needed, although it's still cumbersome.
 
I bumped it up to 10000 characters.  I opened the table in an edit window, selected a long filter, made sure the entire contents of the field was marked, copied it onto my clipboard, and pasted it into Wordpad. 
 
I can work with that, but I was hoping for was a way to get the long filter into some nicely word-wrapped message box or onto the scratch pad or someplace else not on a grid.
 
RobR


From: Thom Brown [mailto:thom@linux.com]
Sent: Monday, November 08, 2010 11:38 AM
To: Rob Richardson
Cc: pgsql-novice@postgresql.org
Subject: Re: [NOVICE] In PgAdmin, how can I see all of a long text field?

On 8 November 2010 16:35, Rob Richardson <Rob.Richardson@rad-con.com> wrote:
My stack_requests table has a field named inventory_filter of type text.  The size of that field is not specified.  It can contain a string several hundred characters long.  Using PgAdmin, how can I see the entire inventory_filter field for a given record no matter how long it is?  A query like "select * from inventory_record where key = 'some_key' " gives me a grid, and no matter how big I make the inventory_filter column, I can't see the whole thing.  Event if I limit my query to the inventory_record column, the display is limited to the width of my monitor, which is often not enough.  How can I use PgAdmin to see the entire field?

In PgAdmin's config, you can change how much is returned:

File > Options > Query Tool > Max. characters per column

--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935