On Fri, Aug 12, 2005 at 06:30:59PM -0700, TJ O'Donnell wrote: > How can I append to the current search_path? > How can I put $user (back) into the search path? > These commands all fail: > set search_path $user,public,gnova; > set search_path \$user,public,gnova; > set search_path '$user',public,gnova;
The last one should succeed if you add "TO" or "=" as the SET documentation shows. http://www.postgresql.org/docs/8.0/static/sql-set.html > Ideally, I would like something like PATH=${PATH}:/usr/local/bin > where I can get the current value and just append to it. You could use the set_config() and current_setting() functions. http://www.postgresql.org/docs/8.0/static/functions-admin.html I'm not aware of a way to append to a variable's current setting with SET, but I'd be happy to be corrected. -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
