From: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Setting global parameter in Postgres 8.3 |
Date: | 2010-01-14 10:10:46 |
Message-ID: | 20100114101046.GF30196@a-kretschmer.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
In response to A(dot)Bhattacharya(at)sungard(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Mead | 2010-01-14 12:35:07 | Re: Setting global parameter in Postgres 8.3 |
Previous Message | A.Bhattacharya | 2010-01-14 09:41:05 | Setting global parameter in Postgres 8.3 |