Re: Create objects(table etc) to be stored in specific schema

Hi Gurus,

I am still picking up skill on postgres and have received a specific requirement.

Create database : DB

Create user: USERA

Schema : SCHEMAC

User USERA should have all the access to create objects/execute in its own schema.

1. I have created database DB with owner as DB(created one user as DB).

2. created user USERA using $createuser command, with role as USERA, no create database/super users  etc are not given
3. Created Schema as - command -"Create schema SCHEMAC authorization USERA"

But objects are getting created in public,
I understand by default its the feature and is looking for assistance in how can I redirect to SCHEMAC.

Any other better way of doing is also welcome.

Thanks

Naresh