问题描述
[抱歉可能的重复:我不能很好地处理......你的Majordomo的...... / :)
技术性...... - :)]
大家好!
[在Debian / Woody上使用PG 7.2.1,k。 2.2.22]
经过长时间的努力,我终于成功转移了旧的
* .dbf文件和相关的* .dbt(别名备注字段) )到一个pg表。
目前我把备忘录字段放在一个单独的表中,该表只有两个
字段(即:n_memo整数,备忘录文本),它可以与视图中的主表相关
.
现在,第一个问题是当我从这个表中选择*时它是
将向上滚动到最后,无论是\ x或\t还是\pset寻呼机是否设置了
! [有关信息:如果我将文本字段放在主要的
ex.dbf表中 - 其中包含更多列 - 或者从视图中选择
连接2个表页面控件工作正常]。
第二个问题:每个文本字段的显示如下:
#----- -----引用---------
- [记录1] ---------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- ----------
col1 |使用艺术学生安排的解剖图
带分析笔记,由James M. Dunlop,ARCA绘制,
...... [cut]。 ...
[单个列表中的示例,但结果相同
$ cols表中的
]
#----------- unquote --------
我的问题是:
1.有没有办法避免显示''---------''行,除了
\ a flag?
2.如果我把备忘录放在主表中,是否有可能
控制备忘录文本字段的显示? [只有部分
记录有备忘录,而且引用col设置为''T'',所以我正在寻找
的选择性指令,例如as:if ctl_memo =''T''显示备忘录,
else,仅显示其他cols。
3.寻呼机在版本7.4.3上是否更好?
我意识到我正在使用的版本(7.2.1)与运行版8.0相比已经过时了,所以你的帮助将是特别感谢。
问候,
Ennio。
-
[Perche''usare Win $ ozz (dico io)se ...anche uno sciocco sa farlo。 \\?//
Fa''qualche cosa di cui non sei capace!" (diceva亨利米勒)](°|°)
[为什么要使用Win $ ozz(我说)如果......即使是傻瓜也能做到这一点。 )=(
做一些你不擅长的事情!(曾经说过Henry Miller)]
------- --------------------(广播结束)------------------------- -
提示6:您是否搜索了我们的列表档案?
我不知道有任何变化。当你有一个占用太多空间的单个
文本字段时会出现问题吗?如果是这样,我会用子字符串构建我的视图
:
创建视图my_view AS
SELECT a,b ,c,substring(long_memo_field,1,80)
FROM ...
HTH
-
Richard Huxton
Archonet Ltd
---------------------- -----(播出结束)---------------------------
提示1:订阅和取消订阅命令转到
[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) ]
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
I''m not aware of any changes. Is the problem when you have a single
text-field that takes up too much space? If so, I''d construct my view
with a substring:
CREATE VIEW my_view AS
SELECT a,b,c,substring(long_memo_field, 1, 80)
FROM ...
HTH
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org
这篇关于显示文本字段的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!