Skip site navigation (1) Skip section navigation (2)

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

From: Thom Brown <thom(at)linux(dot)com>
To: Rob Richardson <Rob(dot)Richardson(at)rad-con(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: In PgAdmin, how can I see all of a long text field?
Date: 2010-11-08 16:37:57
Message-ID: AANLkTikUPqgMHGPoanqjN=vvbiYk5Ax637bxxvaGw3Dz@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
On 8 November 2010 16:35, Rob Richardson <Rob(dot)Richardson(at)rad-con(dot)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

In response to

Responses

pgsql-novice by date

Next:From: Rob RichardsonDate: 2010-11-08 16:55:43
Subject: Re: In PgAdmin, how can I see all of a long text field?
Previous:From: Rob RichardsonDate: 2010-11-08 16:35:21
Subject: In PgAdmin, how can I see all of a long text field?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group