Setting global parameter in Postgres 8.3
От | |
---|---|
Тема | Setting global parameter in Postgres 8.3 |
Дата | |
Msg-id | 4AD2336877609F41A2B0D53BAD09FC57C711A2@VOO-EXCHANGE07.internal.sungard.corp обсуждение исходный текст |
Ответы |
Re: Setting global parameter in Postgres 8.3
|
Список | pgsql-general |
Hi All,
Is there any way we can set the global parameter in Postgres 8.3?
As I have a sql script which need to accept some parameter at run time. For example I have sql script for creating tablespaces called “create_tablespace.sql”
Inside the sql script I have the following statements
CREATE TABLESPACE bank_index_tbsp OWNER bank LOCATION '$drive/data/bank/index_tbsp';
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 will repalce the $drive similar to the way postregs converts or maps the $libdir parameter to the absolute path of the “Lib” location of postgres.
Any help and suggestion will be really helpful.
Many thanks in advance
В списке pgsql-general по дате отправления: