主页 / dba / 问题 / 103210
Accepted
elbarna
Asked: 2015-06-04 17:44:42 +0800 CST

Postgresql：我想要 tro 截断列

  • 772

我有

select * from generale where titolo  ~* 'hp-ux' order by titolo;
      autori       |                                                   titolo                                                    |        casaeditrice        
-------------------+-------------------------------------------------------------------------------------------------------------+----------------------------
 Asghar Ghori      | HP Certified Systems Administrator: Hp-ux 11i V3: Exam Hp0-a01: Training Guide and Adminstrator's Reference | Endeavor Technologies Inc.
 Autori vari       | HP-UX tuning and performance                                                                                | Prentice Hall

Book Entry Hp Certified...等的行标题很长我想截断到这个

 Asghar Ghori      | HP Certified Systems Administrator:....

... 不重要我想将列输出截断为最多 20 个字符，在 oracle 上我使用column titolo format a20如何在 postgres 上执行此操作？谢谢

postgresql

1 个回答

  1. Best Answer

    尝试这个

    select autori, substring(titolo,1,20) || '...'
from generale where titolo  ~* 'hp-ux' order by titolo;

    它会截断您的输出，但不会触及表中的数据

    • 3

相关问题