| From: | "Albe Laurenz" <all(at)adv(dot)magwien(dot)gv(dot)at> |
|---|---|
| To: | "Ashish Karalkar *EXTERN*" <ashish(dot)karalkar(at)info-spectrum(dot)com>, "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Tables not created in proper schema |
| Date: | 2007-07-03 07:08:29 |
| Message-ID: | AFCCBB403D7E7A4581E48F20AF3E5DB203A67BC2@EXADV1.host.magwien.gv.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Ashish Karalkar wrote:
> ${PG_PATH}/psql -d qsweb --command "CREATE SCHEMA qsweb"
>
> ${PG_PATH}/psql -d qsweb --command "ALTER SCHEMA qsweb OWNER TO qsweb"
>
> ${PG_PATH}/psql --command "ALTER USER qsweb SET SEARCH_PATH='qsweb'"
>
>
> The output is right till alter schema but then while setting
> the search path it says NOTICE:schema "qsweb" does not exist.
Hardly surprising, as you forgot '-d qsweb' in the last command.
Yours,
Laurenz Albe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dimitri Fontaine | 2007-07-03 08:47:04 | Re: How-To: Aggregate data from multiple rows into a delimited list. |
| Previous Message | Pavel Stehule | 2007-07-03 06:25:27 | Re: assigning password from script |