[GENERAL] Setting global parameter in Postgres 8.3

[A.Bhattacharya]

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