SEO

#1 (**permalink**) 04-09-2008, 08:09 AM

<< kj314159265358979 >>

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!

kj314159265358979

#2 (**permalink**) 04-09-2008, 08:10 AM

Kynn Jones wrote:
> << kj314159265358979 >>
>
> 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?

You can use psql variables
http://www.postgresql.org/docs/8.1/s...PSQL-VARIABLES

Be careful with quoting issues though.
--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

How to define variables in psql scripts?