Do you know where your variables are? | |
PerlMonks |
Re: conditional backup in postgresby sflitman (Hermit) |
on Jul 16, 2010 at 08:53 UTC ( [id://849944]=note: print w/replies, xml ) | Need Help?? |
I work a lot in postgres and I find pg_dump to be a useful command, since I can call it in a cronjob.
http://www.postgresql.org/docs/current/static/app-pgdump.html I don't think it accepts the Where clause. An alternative would be to run a command like this:
And then you'll have output you could save. Look up the psql command's options, it will probably let you make the output more useful for your backup policy.
HTH,
In Section
Seekers of Perl Wisdom
|
|