|
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 |
