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
No. AFAIK. > 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. Create a function for that ... Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431 2EB0 389D 1DC2 3172 0C99 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
