Re: Setting global parameter in Postgres 8.3
| От | Scott Mead |
|---|---|
| Тема | Re: Setting global parameter in Postgres 8.3 |
| Дата | |
| Msg-id | d3ab2ec81001140435i55b9c6a4nb46cbcb33d5e6bc@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Setting global parameter in Postgres 8.3 ("A. Kretschmer" <andreas.kretschmer@schollglas.com>) |
| Список | pgsql-general |
On Thu, Jan 14, 2010 at 11:10 AM, A. Kretschmer <andreas.kretschmer@schollglas.com> wrote:
In response to A.Bhattacharya@sungard.com :> CREATE TABLESPACE bank_master_tbsp OWNER bank LOCATION ?$drive/data/bank/
> master_tbsp';
>
> CREATE TABLESPACE bank_static_tbsp OWNER bank LOCATION ?$drive /data/bank/
> static_tbsp';
>
>
>
> I need to replace the $drive with a absoulte location in order to create the
> tablespaces at run time.So is there any way I can pass parameter to sql file at
> the time of execuitng it or is there any way I can set a global parameter which
You can't do in it plain sql, but if your script is designed especially for psql, then you could use a psql variable:
--Scott
В списке pgsql-general по дате отправления: