Tables not created in proper schema

Поиск

Список

Период

Сортировка

От	Ashish Karalkar
Тема	Tables not created in proper schema
Дата	2 июля 2007 г. 02:48:48
Msg-id	004001c7bc6b$fd4ea220$170211ac@LIONKING.COM обсуждение исходный текст
Ответы	Re: Tables not created in proper schema
Список	pgsql-general

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 /usr/local/pgsql/QS/QS_100_2_Create_Table.sql -q -1

But still the tables are created in the public schema and not in xyz schema

Postgresql.conf entry:

serach path =' "$user",public'

tried with setting :

search path = ' xyz,"$user",public'

Same result

search path = ' "$user",xyz,public'

Same result

search path = ' "$user",xyz'

Error:no schema has been selected to create in

Please suggest me the corrective action.

Thanks In advance

Ashish...

В списке pgsql-general по дате отправления: