Display of text fields
От | Ennio-Sr |
---|---|
Тема | Display of text fields |
Дата | |
Msg-id | 20040902150859.GA3183@deby.ei.hnet обсуждение исходный текст |
Ответы |
Re: Display of text fields
|
Список | pgsql-general |
[Sorry for possible pluri-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 a view connecting the 2 tables 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., ..... [ cut ] .... [Example taken from a single column table, but the result is the same for the 2 cols table] # ----------- unquote -------- 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. Regards, Ennio. -- [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 по дате отправления: