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(at)turnstep(dot)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(at)turnstep(dot)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
>