Re: Question on Table creation

Поиск
Список
Период
Сортировка
От Lok P
Тема Re: Question on Table creation
Дата
Msg-id CAKna9VYQNmiDeEgRMian8oGAF0raa7SVA3GxTU=EtCEHVySAPQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Question on Table creation  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: Question on Table creation
Список pgsql-general
"1)In this situation , do we have to drop the  "Schema_Owner"  and recreate it with all small letters? And then create the schema with small letters again?"

As per above question goes, I believe OP is not required to drop and recreate but has to just Rename the user something as below and that would remove the case sensitiveness making all lower case. and the same thing can be done for the schema too. 

ALTER USER "Schema_Owner"   RENAME TO  Schema_Owner ;
ALTER schema "Schema_Name"   RENAME TO Schema_Name;

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

Предыдущее
От: Johnathan Tiamoh
Дата:
Сообщение: Re: User pooler error: unsupported startup parameter: extra_float_digits
Следующее
От: Alec Lazarescu
Дата:
Сообщение: Re: Partitioning options