dropTRIGGER: Generate a PostgreSQL DROP TRIGGER statement, optionally...

In pgTools: Functions for Generating PostgreSQL Statements/Scripts

Generate a PostgreSQL DROP TRIGGER statement, optionally execute the statement if con is not NULL.

Description

Generate a PostgreSQL DROP TRIGGER statement, optionally execute the statement if con is not NULL.

Usage

dropTRIGGER(
  name,
  on,
  if_exists = FALSE,
  cascade = FALSE,
  restrict = FALSE,
  con = NULL
)

Arguments

name	A string, the "name" parameter for PostgreSQL DROP TRIGGER.
on	A string, the "table_name" parameter for PostgreSQL DROP TRIGGER.
if_exists	TRUE/FALSE, if TRUE, adds "IF EXISTS" to PostgreSQL DROP TRIGGER statement.
cascade	TRUE/FALSE, if TRUE, adds "CASCADE" to PostgreSQL DROP TRIGGER statement.
restrict	TRUE/FALSE, if TRUE, adds "RESTRICT" to PostgreSQL DROP TRIGGER statement.
con	A database connection that can be passed to DBI::dbSendQuery/DBI::dbGetQuery.

Value

A string, PostgreSQL DROP TRIGGER statement; or the results retrieved by DBI::dbSendQuery after executing the statement.

Examples

dropTRIGGER(
name = "sample_trigger",
on = "sample_table"
)

pgTools documentation built on March 31, 2023, 7:56 p.m.