Hi there,

is't possible to specify default search path for dbh in DBD::Pg ?
I don't want to set variable before every select.

	Regards,
		Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

Wed, 23 Jul 2003 08:14:21 +0400 (MSD)
Oleg Bartunov <oleg@sai.msu.su>
DBD::Pg, schema support

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


> is't possible to specify default search path for dbh in DBD::Pg ?
> I don't want to set variable before every select.

There is nothing specific to DBD::Pg, but you should be able to issue 
the command once ("SET search_path...") and have all subsequent 
requests on the same database handle use that schema.

- --
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200307231328

-----BEGIN PGP SIGNATURE-----
Comment: http://www.turnstep.com/pgp.html

iD8DBQE/HsXXvJuQZxSWSsgRArfEAJ4+mIE7fTXnvf3JHS2Y3WmSoZwO/QCgxpx0
RuTjTUI3hngy2T9BMqDEXpE=
=tvul
-----END PGP SIGNATURE-----


Wed, 23 Jul 2003 17:30:43 -0000
greg@turnstep.com
Re: DBD::Pg, schema support
Can you give an example on how to execute that command?  I've been 
wondering about that too but haven't had time to read the documentation.


Richard


On 2003.07.23 10:30 greg@turnstep.com wrote:
> 
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> 
> > is't possible to specify default search path for dbh in DBD::Pg ?
> > I don't want to set variable before every select.
> 
> There is nothing specific to DBD::Pg, but you should be able to issue
> the command once ("SET search_path...") and have all subsequent
> requests on the same database handle use that schema.
> 
> - --
> Greg Sabino Mullane greg@turnstep.com
> PGP Key: 0x14964AC8 200307231328
> 
> -----BEGIN PGP SIGNATURE-----
> Comment: http://www.turnstep.com/pgp.html
> 
> iD8DBQE/HsXXvJuQZxSWSsgRArfEAJ4+mIE7fTXnvf3JHS2Y3WmSoZwO/QCgxpx0
> RuTjTUI3hngy2T9BMqDEXpE=
> =tvul
> -----END PGP SIGNATURE-----
> 
> 
> ---------------------------(end of 
> broadcast)---------------------------
> TIP 8: explain analyze is your friend
> 

Wed, 23 Jul 2003 15:24:11 -0700
Richard Schilling <rschilling@nationalinformatics.net>
Re: DBD::Pg, schema support
On Wed, 2003-07-23 at 18:24, Richard Schilling wrote:
> Can you give an example on how to execute that command?  I've been 
> wondering about that too but haven't had time to read the documentation.

SET search_path TO foo,'$user',public;

http://developer.postgresql.org/docs/postgres/runtime-config.html


24 Jul 2003 00:30:51 -0400
Arguile <arguile@lucentstudios.com>
Re: DBD::Pg, schema support