On Tue, Oct 22, 2013 at 8:07 AM, James Sewell <james.sew...@lisasoft.com>wrote:
> Hello, > > I need to trigger a database dump from a SQL script (or function, but I > think that is even less likely). > > I know I can do: > > \! pg_dumpall > /mydir/myfile > > Which is fine, but I need to use a variable to set the name. > > \set myfile 'filename' > \! pg_dumpall > /mydir/:myfile > > Doesn't seem to work. > > Any ideas? > Below URL provides more information of Automated database Backup's on Linux: http://wiki.postgresql.org/wiki/Automated_Backup_on_Linux Thanks & Regards Raghu Ram
