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

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

From: "Rob Richardson" <Rob(dot)Richardson(at)rad-con(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: In PgAdmin, how can I see all of a long text field?
Date: 2010-11-08 16:35:21
Message-ID: 04A6DB42D2BA534FAC77B90562A6A03D01615F63@server.rad-con.local (view raw or flat)
Thread:
Lists: pgsql-novice
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
 

Responses

pgsql-novice by date

Next:From: Thom BrownDate: 2010-11-08 16:37:57
Subject: Re: In PgAdmin, how can I see all of a long text field?
Previous:From: Frank BaxDate: 2010-11-08 12:19:32
Subject: Re: Restaring a dumped database

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