Re: How to define variables in psql?

From: A. Kretschmer <andreas(dot)kretschmer(at)schollglas(dot)com>
Date: Jan 31, 2006 8:20 AM
Subject: Re: [NOVICE] How to define variables in psql?
To: pgsql-novice(at)postgresql(dot)org

am 31.01.2006, um 7:17:17 -0500 mailte kynn(at)panix(dot)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

Yes, exactly. Thanks.

kj