How to use postgres sql

Question

As shown in the video sqlite 3 is default, Is there a way to make postgres sql default ?

Viktor Panasyuk · Answer

You should change settings.py, especially this line - DATABASES = {...}
More here:
Database
https://docs.djangoproject.com/en/2.1/ref/settings/#databases
"When connecting to other database backends, such as MySQL, Oracle, or PostgreSQL, additional connection parameters will be required. See the ENGINE setting below on how to specify other database types. This example is for PostgreSQL:
DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql',
        'NAME': 'mydatabase',
        'USER': 'mydatabaseuser',
        'PASSWORD': 'mypassword',
        'HOST': '127.0.0.1',
        'PORT': '5432',
    }
}"

Welcome to the Treehouse Community

Looking to learn something new?

Raza Haider

Raza Haider

How to use postgres sql

1 Answer

Viktor Panasyuk

Viktor Panasyuk

Database

https://docs.djangoproject.com/en/2.1/ref/settings/#databases