On Tue, Oct 22, 2013 at 7:20 AM, James Sewell <james.sewell@xxxxxxxxxxxx> 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 from a :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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general