Re: Question on Table creation - Mailing list pgsql-general

From Lok P
Subject Re: Question on Table creation
Date
Msg-id CAKna9VYQNmiDeEgRMian8oGAF0raa7SVA3GxTU=EtCEHVySAPQ@mail.gmail.com
Whole thread Raw
In response to Re: Question on Table creation  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Question on Table creation  (sud <suds1434@gmail.com>)
List 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 by date:

Previous
From: Johnathan Tiamoh
Date:
Subject: Re: User pooler error: unsupported startup parameter: extra_float_digits
Next
From: Alec Lazarescu
Date:
Subject: Re: Partitioning options