forked from pgMemento/pgMemento
-
Notifications
You must be signed in to change notification settings - Fork 0
/
STOP_AUDITING.sql
28 lines (25 loc) · 978 Bytes
/
STOP_AUDITING.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
-- STOP_AUDITING.sql
--
-- Author: Felix Kunde <felix-kunde@gmx.de>
--
-- This script is free software under the LGPL Version 3
-- See the GNU Lesser General Public License at
-- http://www.gnu.org/copyleft/lgpl.html
-- for more details.
-------------------------------------------------------------------------------
-- About:
-- Script to stop auditing for a given database schema
-------------------------------------------------------------------------------
--
-- ChangeLog:
--
-- Version | Date | Description | Author
-- 0.1.0 2016-03-09 initial commit FKun
--
\pset footer off
SET client_min_messages TO WARNING;
\set ON_ERROR_STOP ON
\echo
\prompt 'Please enter the name of the schema that is used along with pgMemento: ' schema_name
\prompt 'Specify tables that were not logged (separated by comma): ' except_tables
\i ctl/STOP.sql