Search Postgresql Archives

Re: Loading a list of SQL scripts with relative paths

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




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)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux