On May 11, 2005, at 3:58, Leif B. Kristensen wrote:
On Tuesday 10 May 2005 17:24, Michael Glaesemann wrote:This works well, but I think I'll have to change all of the paths when I move the group of scripts to the production server to load them. What I'd like to do is be able to use paths relative to the file that contains the \i commands. This doesn't seem to work when using \i.
I imagine that I'm not alone in wanting to load a bunch of scripts at a go, and I'm wondering how others handle this situation. Advice? Suggestions? What works for you?
I had a similar problem, which I solved by using environment variables:
<snip />
Here's the whole thread:
<http://www.mail-archive.com/pgsql-general@xxxxxxxxxxxxxx/ msg60216.html>
--
Thanks, Leif, for the great summary of your technique! I'll definitely give it a go.
Michael Glaesemann grzm myrealbox com
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)