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