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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
