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

Display of text fields

From: Ennio-Sr <nasr(dot)laili(at)tin(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: Display of text fields
Date: 2004-08-25 14:15:13
Message-ID: 20040825141513.GB28144@deby.ei.hnet (view raw, whole thread or download thread mbox)
Lists: pgsql-general
[Sorry for possible repeat: I'm not putting up very well with the
technicalities of ... your Majordomo ... -:)]

Hi all!

[Using PG 7.2.1 on Debian/Woody, k. 2.2.22]

After a very long struggle I finally succeded in transferring my old
*.dbf file and the relating *.dbt (alias memo fields) to a pg table.
For the time being I put the memo field in a separate table having two
fields only (i.e.: n_memo integer, memo text) which can be related to
the main table in a view.

Now, the first problem is that when I do a select * from this table it
will scroll up to the end, no matter whether \x or \t or \pset pager are
set or not!  [For information: if I put the text fields in the main
ex.dbf table - which has more columns - or do a select from the view,
the page control works fine].

Second problem: the display of each text field looks like this:

# ---------- quote ---------
-[ RECORD 1 ]--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
col1 |    Anatomical Diagrams for the use of the Art Students Arranged with analytical Notes and drawn out by James M. Dunlop, A.R.C.A., Antique and Life Class Master and Lecturer on Artistic Anatomy in the Glascow School of Art. With Introductory Preface by John Cleland, M.D., LL.D., F.R.S., Professor of Anatomy in the University of Glascow Fourth Edition [Present of Mrs ...]  London. G. Bell & Sons Ltd. MDCCCCXVIII pp.  8 + 72 tavv., ril. ed. 18,5x26.7 Siena, lugl. 2002 Ancilli 

[Example taken from a single column table, but the result is the same
for the 2 cols table]

# ----------- unquote --------

The display is no better with pgaccess on a graphic Xterm: the field
size does not adjust to the content of the text field, so that 
it becomes very difficult to read large texts.

My questions are then:

1. Is there a way to avoid displaying the '---------' lines, apart from
   the \a flag ?
2. In case I put the memos in the main table, would it be possible to
   control someway the display of memo-text fields? [Only some of the
   records have a memo, and a referring col set to 'T', so I'm looking
   for a selective instruction, such as: if ctl_memo='T' display memo,
   else, display the other cols only].
3. Does the pager work better on version 7.4.3?

I realize that the version (7.2.1) I'm working with is old as compared
to the running 8.0, so your help will be particularly appreciated.

[Perche' usare Win$ozz (dico io) se ..."anche uno sciocco sa farlo.     \\?//
 Fa' qualche cosa di cui non sei capace!"   (diceva Henry Miller) ]     (°|°)
[Why to use Win$ozz (I say) if ... "even a fool can do that.             )=(
 Do something you aren't good at!" (used to say Henry Miller) ]

pgsql-general by date

Next:From: Lincoln YeohDate: 2004-08-25 14:35:15
Subject: Re: UTF-8 and LIKE vs =
Previous:From: David Suela FernándezDate: 2004-08-25 14:08:18
Subject: Re: copy a database

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