Re: Tables not created in proper schema - Mailing list pgsql-general

From Albe Laurenz
Subject Re: Tables not created in proper schema
Date
Msg-id AFCCBB403D7E7A4581E48F20AF3E5DB203A67BC2@EXADV1.host.magwien.gv.at
Whole thread Raw
In response to Tables not created in proper schema  ("Ashish Karalkar" <ashish.karalkar@info-spectrum.com>)
List 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

pgsql-general by date:

Previous
From: "Pavel Stehule"
Date:
Subject: Re: assigning password from script
Next
From: Dimitri Fontaine
Date:
Subject: Re: How-To: Aggregate data from multiple rows into a delimited list.