| From: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: set the default schema |
| Date: | 2006-11-21 06:08:07 |
| Message-ID: | 20061121060807.GB24314@a-kretschmer.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
am Mon, dem 20.11.2006, um 19:59:17 +0100 mailte Alain Roger folgendes:
> Hi,
>
> I do not own my database. in fact, it is stored on my web hoster server.
> therefore i would like to know how can i setup the default SCHEMA in order to
> no have to write in all my functions, queries or procedures, the following
> thing :
alter user <your_user> set search_path=<insert your favorite search_path here);
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47215, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | blackjadelin | 2006-11-21 07:39:13 | where to download postgresql-server-7.2.2-1.i386.rpm? |
| Previous Message | A. Kretschmer | 2006-11-21 06:05:53 | Re: Extract between year *and* month |