<!--

$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_trigger.sgml,v 1.9 2000/03/27 17:14:42 thomas Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_trigger.sgml,v 1.10 2000/04/07 19:20:48 momjian Exp $

Postgres documentation

-->

<synopsis>

CREATE TRIGGER <replaceable class="PARAMETER">name</replaceable> { BEFORE | AFTER } { <replaceable class="PARAMETER">event</replaceable> [OR ...] }

ON <replaceable class="PARAMETER">table</replaceable> FOR EACH { ROW | STATEMENT }

EXECUTE PROCEDURE <replaceable class="PARAMETER">ER">func</replaceable>BLE> ( <replaceable class="PARAMETER">arguments</replaceable> )

EXECUTE PROCEDURE <replaceable class="PARAMETER">func</replaceable> ( <replaceable class="PARAMETER">arguments</replaceable> )

</synopsis>

<refsect2 id="R2-SQL-CREATETRIGGER-1">

<!--

$Header: /cvsroot/pgsql/doc/src/sgml/ref/revoke.sgml,v 1.8 1999/07/22 15:09:14 thomas Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/ref/revoke.sgml,v 1.9 2000/04/07 19:20:48 momjian Exp $

Postgres documentation

-->

<synopsis>

REVOKE <replaceable class="PARAMETER">privilege</replaceable> [, ...]

ON <replaceable class="PARAMETER">object</replaceable> [, ...]

FROM { PUBLIC | GROUP <replaceable class="PARAMETER">ER">g</replaceable>BLE> | <replaceable class="PARAMETER">username</replaceable> }

FROM { PUBLIC | GROUP <replaceable class="PARAMETER">groupname</replaceable> | <replaceable class="PARAMETER">username</replaceable> }

</synopsis>

<refsect2 id="R2-SQL-REVOKE-1">