Thread: how to display long records.

how to display long records.

From
Jack Craig
Date:
Hi PG Support folks,<br /><br />I am using pgadmin3 1.14.3 on Linux.<br /><br />after laying out a record with a 2k
bytefield at the end of the row, the pgadmin<br />doesnt want to show me the full record.<br /><br />how do i get to
scrollto the far right to see the full row?<br /><br />TIA< jackc..<br /> 

Re: how to display long records.

From
jack craig
Date:
I am wondering why no reply to this query?

No one knows or its a well know limitation to the query tool?

I find it hard to believe there is no way to display long string fields...

I did set the string display option from 256 -> 1024, but no joy...

Comments?

TIZ...



--
View this message in context:
http://postgresql.1045698.n5.nabble.com/how-to-display-long-records-tp5721423p5721605.html
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.



Re: how to display long records.

From
Chandrakant G
Date:
On Tuesday, August 28, 2012 1:50:41 PM UTC-4, jack craig wrote:
> I am wondering why no reply to this query?
> 
> 
> 
> No one knows or its a well know limitation to the query tool?
> 
> 
> 
> I find it hard to believe there is no way to display long string fields...
> 
> 
> 
> I did set the string display option from 256 -> 1024, but no joy...
> 
> 
> 
> Comments?
> 
> 
> 
> TIZ...
> 
> 
> 
> 
> 
> 
> 
> --
> 
> View this message in context:
http://postgresql.1045698.n5.nabble.com/how-to-display-long-records-tp5721423p5721605.html
> 
> Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.
> 
> 
> 
> 
> 
> -- 
> 
> Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
> 
> To make changes to your subscription:
> 
> http://www.postgresql.org/mailpref/pgadmin-support

Please post a screenshot. This is hard to determine with just a description.



Re: how to display long records.

From
Jack Craig
Date:
sure, look at the logrecord field...

Thx!

On Tue, Aug 28, 2012 at 10:55 AM, Chandrakant G <chandrakant.gopalan@gmail.com> wrote:
On Tuesday, August 28, 2012 1:50:41 PM UTC-4, jack craig wrote:
> I am wondering why no reply to this query?
>
>
>
> No one knows or its a well know limitation to the query tool?
>
>
>
> I find it hard to believe there is no way to display long string fields...
>
>
>
> I did set the string display option from 256 -> 1024, but no joy...
>
>
>
> Comments?
>
>
>
> TIZ...
>
>
>
>
>
>
>
> --
>
> View this message in context: http://postgresql.1045698.n5.nabble.com/how-to-display-long-records-tp5721423p5721605.html
>
> Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.
>
>
>
>
>
> --
>
> Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
>
> To make changes to your subscription:
>
> http://www.postgresql.org/mailpref/pgadmin-support

Please post a screenshot. This is hard to determine with just a description.


--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

Attachment

Re: how to display long records.

From
Guillaume Lelarge
Date:
On Mon, 2012-08-27 at 11:46 -0700, Jack Craig wrote:
> Hi PG Support folks,
> 
> I am using pgadmin3 1.14.3 on Linux.
> 
> after laying out a record with a 2k byte field at the end of the row, the
> pgadmin
> doesnt want to show me the full record.
> 
> how do i get to scroll to the far right to see the full row?
> 

You click on the right edge of the column and push it on the right.
Works for me.


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com




Re: how to display long records.

From
Jack Craig
Date:
Thanks Chandrakant, new to the list...

I appreciate this verification.

On Tue, Aug 28, 2012 at 2:16 PM, Chandrakant G <chandrakant.gopalan@gmail.com> wrote:
Yes this is a limitation of the editor. You have to select fewer columns or resize the other columns manually to be smaller so that you can drag the column size more to see more visible data. If there are newlines in your data, then you can drag the row down to see the whole string.

Btw I didnt see this email in the group so I am replying to you personally here.

Thanks
CG

On Tue, Aug 28, 2012 at 4:41 PM, Jack Craig <jack.craig.aptos@gmail.com> wrote:
sure, look at the logrecord field...

Thx!

On Tue, Aug 28, 2012 at 10:55 AM, Chandrakant G <chandrakant.gopalan@gmail.com> wrote:
On Tuesday, August 28, 2012 1:50:41 PM UTC-4, jack craig wrote:
> I am wondering why no reply to this query?
>
>
>
> No one knows or its a well know limitation to the query tool?
>
>
>
> I find it hard to believe there is no way to display long string fields...
>
>
>
> I did set the string display option from 256 -> 1024, but no joy...
>
>
>
> Comments?
>
>
>
> TIZ...
>
>
>
>
>
>
>
> --
>
> View this message in context: http://postgresql.1045698.n5.nabble.com/how-to-display-long-records-tp5721423p5721605.html
>
> Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.
>
>
>
>
>
> --
>
> Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
>
> To make changes to your subscription:
>
> http://www.postgresql.org/mailpref/pgadmin-support

Please post a screenshot. This is hard to determine with just a description.


--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support



Re: how to display long records.

From
Jack Craig
Date:
 doesnt want to show me the full record.
>
> how do i get to scroll to the far right to see the full row?
>

You click on the right edge of the column and push it on the right.
Works for me.


well, within the default query pane size, that doesn't do much, But!

your suggestion led me to resize the entire pane, then i could drag it out!!!

So, Thanks and enjoy the SeeGar you won for playing, ... :)


Re: how to display long records.

From
jack craig
Date:
 doesnt want to show me the full record.
>
> how do i get to scroll to the far right to see the full row?
>

You click on the right edge of the column and push it on the right.
Works for me.


well, within the default query pane size, that doesn't do much, But!

your suggestion led me to resize the entire pane, then i could drag it out!!!

So, Thanks and enjoy the SeeGar you won for playing, ... :)