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
>