# \[external-db pgsql\] - awx-migrate possibly to create table in a order schema than public ?

**URL:** <https://forum.ansible.com/t/external-db-pgsql-awx-migrate-possibly-to-create-table-in-a-order-schema-than-public/33356>\
**Category:** AWX Project\
**Tags:** awx\
**Created:** [July 9, 2020, 7:44am UTC](https://forum.ansible.com/t/external-db-pgsql-awx-migrate-possibly-to-create-table-in-a-order-schema-than-public/33356 "2020-07-09T07:44:05Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Benoit\_Barriere](https://avatars.discourse-cdn.com/v4/letter/b/8e7dd6/32.png) [@Benoit\_Barriere](https://forum.ansible.com/u/Benoit_Barriere)\
**Post date:** [July 9, 2020, 7:44am UTC](https://forum.ansible.com/t/external-db-pgsql-awx-migrate-possibly-to-create-table-in-a-order-schema-than-public/33356/1 "2020-07-09T07:44:05Z")

</div>

Hello,

I have get this following bellow error because the command awx-migrate (django command) push and create pgsql data in public schema. My dba by default create a separate schema for each DB created in our cluster posqtgresql to be more clean and secure.

raise MigrationSchemaMissing(“Unable to create the django\_migrations table (%s)” % exc)  
django.db.migrations.exceptions.MigrationSchemaMissing: Unable to create the django\_migrations table (permission denied for schema public  
LINE 1: CREATE TABLE “django\_migrations” (“id” serial NOT NULL PRIMA…

So is possible to parameter anywhere the schema name for the DB ?

regards

Benoit