Question

Crear tablas y modificar estructura de otras en Postgrsql con migrate

Posted on November 10, 2023
Database
Asked by proysistem

Saludos. Despues de hacer un git pull, puedo con migrate crear mas tablas y actualizar la estructura de otras en postgresql. Trabajando con django.

Submit an answer

This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

KFSys

Site Moderator

• November 10, 2023

Greetings!

After performing a git pull, you can indeed use Django’s migrate command to create more tables and update the structure of existing ones in a PostgreSQL database.

When you git pull in a Django project, you’re typically pulling in changes that include updates to Django models. These model changes might be new models (which correspond to new tables in your database) or modifications to existing models (which might require changes to the structure of existing tables).

Here’s how the process typically works:

Git Pull: First, you execute git pull to update your local codebase with the latest changes from the repository.
Check for Model Changes: After pulling the changes, you should check if there are any changes in the Django models (located in the models.py files of your Django apps).
Create Migrations: If there are model changes, you need to create new migration files. You do this by running python manage.py makemigrations. This command will generate migration scripts that represent the changes to your database schema.
Apply Migrations: To apply these changes to your PostgreSQL database, you run python manage.py migrate. This command executes the migration scripts, thereby creating new tables or altering existing ones according to the changes in your models.
Verify Database Schema: After running the migrations, your database schema should be updated. You can verify this by checking the database directly or using Django’s admin interface if it’s set up.

It’s important to ensure that the database your Django project connects to is accessible and correctly configured in your settings.py file. Also, make sure that your PostgreSQL user has the necessary permissions to create and modify tables.

Remember, the migrate command applies all pending migrations, not just the ones related to the latest git pull. So it’s a good practice to regularly pull changes and keep your database schema synchronized with your model definitions.