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 setti
schmer" <[EMAIL PROTECTED]>
To:
Sent: Monday, July 02, 2007 2:28 PM
Subject: Re: [GENERAL] Tables not created in proper schema
am Mon, dem 02.07.2007, um 11:13:54 +0530 mailte Ashish Karalkar
folgendes:
Hello All,
I am trying to create databse with script.
I run this script from root
am Mon, dem 02.07.2007, um 11:13:54 +0530 mailte Ashish Karalkar folgendes:
> Hello All,
> I am trying to create databse with script.
> I run this script from root prompt with command
>
>
> $ su - postgres -c 'path to script.sql'
>
>
> In the script I follow following steps
>
>
> 1) cr