Re: pg_dumpall from a script - Mailing list pgsql-general

On Tue, Oct 22, 2013 at 7:20 AM, James Sewell <james.sewell@lisasoft.com> wrote:

> I need a way to backup either from SQL in PSQL (possibly \!) or from a PG/PLSQL function to a file with a name set
froma :variable. 

Could it be something like this:

# \setenv myFile 'filename'
# \! pg_dump > $myFile

Unfortunately there seems to be no unsetenv command to remove the
variable within the script.


Luca