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

am  31.01.2006, um  7:17:17 -0500 mailte kynn@panix.com folgendes:
>
>
>
> 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


something like this:?

\set DIR /home/kretschmer/
\set file :DIR foobar.sql

\set DB FOOBAR

\i :file

\echo "done with " :DB




HTH, Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47215,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===