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

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/static/app-psql.html#APP-PSQL-VARIABLES

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