I want to backup a database but exclude certain schemas with a patter.
I have 100 schemas with the pattern: 'sch_000', 'sch_001', and so on.
Will this work?
$pg_dump --exclude-schema='sch_*'
this does not seem to exclude all schemas with this pattern ( 'sch_*' ),
anything wrong here?
than
Before running a script (invoked by .sh that will call stored procs which
may invoke other triggers), I want to capture every change made in the
database which includes the field value before the update and the field
value after the update and also capture all inserts.
With this data, I would be a
I have reviewed working with dates documentation but some things are not
clear and I cannot get an example to work for what I need.
I am passing a date into a stored function like '2013-04-01'
The stored function accepts this string as a date type.
Within the function, I need to:
1. subtract o
for result data
On Thu, Feb 6, 2014 at 10:31 AM, Adrian Klaver wrote:
> On 02/06/2014 09:25 AM, Jay Vee wrote:
>
>> I have reviewed working with dates documentation but some things are not
>> clear and I cannot get an example to work for what I need.
>>
>> I am pa
