主页 / dba / 问题 / 143845
Accepted
dw8547
Asked: 2016-07-15 01:30:43 +0800 CST

如何将较长的 PL/pgSQL 代码行拆分为多行？

  • 772

有没有办法将一长串 PL/pgSQL 代码拆分为多行？我的上下文是一个触发函数，我按照以下方式将插入记录到表中：

INSERT INTO insert_log (log_time, description)
VALUES (
    now()
    , 'A description. Made up of 3 semi long sentences. That I want to split, in the code, not in the log table, over 3 lines for readability.'
);
postgresql-9.4

1 个回答

  1. Best Answer

    字符串常量可以拆分为多行，如手册中所述

    INSERT INTO insert_log (log_time, description)
VALUES (
    now()
    , 'A description. Made up of 3 semi long sentences. '
      'That I want to split, in the code, not in the log table, '
      'over 3 lines for readability.'
);
    • 38

相关问题