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

From Richard Huxton
Subject Re: How to define variables in psql scripts?
Date
Msg-id 43DF8042.6010405@archonet.com
Whole thread Raw
In response to How to define variables in psql scripts?  ("Kynn Jones" <kynnjo@gmail.com>)
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

pgsql-general by date:

Previous
From: nboutelier@hotmail.com
Date:
Subject: Can't get the field = ANY(array) clause to work...
Next
From: "P. Scott DeVos"
Date:
Subject: plpython error logs