Postgres Pro
Downloads
Home   >   mailing lists

Function to total reset a schema - Mailing list pgsql-sql

From Surfing
Subject Function to total reset a schema
Date
Msg-id 4DE103A5.9030900@gmail.com
Whole thread Raw
List pgsql-sql
Tree view 
Hi all,
I need to write a function that totally empty a schema.

So I have written a TRUNCATE statement for each table and set to 0 each 
sequence.
Btw, it could be good to execute a vacuum statement on each table, but 
from within the function this is not allowed.

Is there a way to obtain the same result in another way (without using 
the vacuum)?

Thanks

pgsql-sql by date:

Previous
From: Rob Sargent
Date:
Subject: Re: Function to total reset a schema
Next
From: Jasen Betts
Date:
Subject: Re: Order of evaluation in triggers for checks on inherited table partitions