Re: [GENERAL] Tables not created in proper schema

2007-07-03 Thread Albe Laurenz
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

Re: [GENERAL] Tables not created in proper schema

2007-07-02 Thread Ashish Karalkar
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

Re: [GENERAL] Tables not created in proper schema

2007-07-02 Thread A. Kretschmer
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