On Thu, Jan 14, 2010 at 11:10 AM, A. Kretschmer < andreas.kretsch...@schollglas.com> wrote:
> In response to a.bhattacha...@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: http://www.postgresql.org/docs/current/static/app-psql.html#APP-PSQL-VARIABLES --Scott
