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
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) create user
: 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 prompt with command
$ su - postgres -c 'path
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) create user xyz
2) create database xyz -O xyz
3) create schema xyz
4) {PG_PATH}/psql -d xyz -U xyz -f