How to define variables in psql? - Mailing list pgsql-novice

From
Subject How to define variables in psql?
Date
Msg-id 200601311217.k0VCHH712178@panix3.panix.com
Whole thread Raw
Responses Re: How to define variables in psql?
List pgsql-novice


I know that one can store multiple psql commands and SQL statements in
a separate "script" file, and then "source" the script file, e.g. with
the \i command.

My question is, can I define variables in such a script file?
E.g. can I do something like the following unix-shell-like script?

-- beginning of script

DB=frobozz
DIR=/foo/bar/baz/quux

\c $frobozz
\i "$DIR/other_script.sql"
\i "$DIR/one_more_script.sql"
\i "$DIR/yas.sql"

\echo "done with $DB"

-- end of script

Thanks!

kj

pgsql-novice by date:

Previous
From: Clifton Zama
Date:
Subject: copy
Next
From: Tomka Gergely
Date:
Subject: lost archives, alpha data files