Skip to main content

Add default field value in Django migrations for PostgreSQL

Project description

Django Add Default Value for PostgreSQL

Django Migration Operation that can be used to transfer a field's default value to the database scheme.

Based on django-add-default-value by 3YOURMIND. This variant drops support for other databases, specifically the Azure ODBC driver which does not support current versions of Django.

CI PyPi License


  • Python 3.6, 3.7, or 3.8
  • Django 2.2 or 3.0


pip install django-add-default-value-postgresql

You can then use AddDefaultValue in your migration file to transfer the default values to your database. Afterwards, it's just the usual ./ migrate.


Add this manually to an autogenerated Migration that adds a new field:



Given the following migration:

operations = [
        field=models.CharField(default='my_default', max_length=255),

Modify the migration to add a default value:

+from django_add_default_value import AddDefaultValue
 operations = [
         field=models.CharField(default='my_default', max_length=255),
+    AddDefaultValue(
+        model_name='my_model',
+        name='my_field',
+        value='my_default'
+    )

If you check python sqlmigrate [app name] [migration], you will see that the default value now gets set.


You can test against multiple versions of Django using tox. To test across Python versions, use pyenv to run tox under each version.


django-add-default-value-postgresql is released under the Apache 2.0 License, based on django-add-default-value by 3YOURMIND which is also released under the Apache 2.0 License.

Changes from original source

  • removed MySQL-related code
  • removed MSSQL-related code
  • added allow_migrate_model check on database_forwards and database_backwards
  • added support for Python 3.7 and 3.8, dropped support for <3.6
  • added support for Django 2.2 and 3.0, dropped support for <2.2

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Huawei Huawei PSF Sponsor Microsoft Microsoft PSF Sponsor NVIDIA NVIDIA PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page