2
$PostgreSQL: pgsql/doc/src/sgml/ref/alter_trigger.sgml,v 1.8 2003-11-29 19:51:38 pgsql Exp $
3
PostgreSQL documentation
6
<refentry id="SQL-ALTERTRIGGER">
8
<refentrytitle id="sql-altertrigger-title">ALTER TRIGGER</refentrytitle>
9
<refmiscinfo>SQL - Language Statements</refmiscinfo>
13
<refname>ALTER TRIGGER</refname>
14
<refpurpose>change the definition of a trigger</refpurpose>
17
<indexterm zone="sql-altertrigger">
18
<primary>ALTER TRIGGER</primary>
23
ALTER TRIGGER <replaceable class="PARAMETER">name</replaceable> ON <replaceable class="PARAMETER">table</replaceable> RENAME TO <replaceable class="PARAMETER">newname</replaceable>
28
<title>Description</title>
31
<command>ALTER TRIGGER</command> changes properties of an existing
32
trigger. The <literal>RENAME</literal> clause changes the name of
33
the given trigger without otherwise changing the trigger
38
You must own the table on which the trigger acts to be allowed to change its properties.
43
<title>Parameters</title>
47
<term><replaceable class="PARAMETER">name</replaceable></term>
50
The name of an existing trigger to alter.
56
<term><replaceable class="PARAMETER">table</replaceable></term>
59
The name of the table on which this trigger acts.
65
<term><replaceable class="PARAMETER">newname</replaceable></term>
68
The new name for the trigger.
76
<title>Examples</title>
79
To rename an existing trigger:
81
ALTER TRIGGER emp_stamp ON emp RENAME TO emp_track_chgs;
87
<title>Compatibility</title>
90
<command>ALTER TRIGGER</command> is a <productname>PostgreSQL</>
91
extension of the SQL standard.
96
<!-- Keep this comment at the end of the file
101
sgml-minimize-attributes:nil
102
sgml-always-quote-attributes:t
105
sgml-parent-document:nil
106
sgml-default-dtd-file:"../reference.ced"
107
sgml-exposed-tags:nil
108
sgml-local-catalogs:"/usr/lib/sgml/catalog"
109
sgml-local-ecat-files:nil