So it is quite easy and I think natural if you want to use another DBMS, such as my school or another
database in PostgreSQL.
Well, so I'm going to change the current database to another one in PostgreSQL.
Well.
But before I do that, I need to create a database.
So these are my workspaces, but I'm not going to need them now.
So I'm going to disconnect from the MSF three database.
Then exit from Métis Point.
Now, I think it's good practice to stop PostgreSQL for a while, then started again, but this is just
one of my old habits.
That I pass on to you.
OK, so now I'm going to get the full name of the PostgreSQL user by these commands.
Name is most grass type as you post grass to get into PostgreSQL.
Well, use Herschelle.
Now, here, you're not going to need a password because the default installation, there is no password.
Now, the logic is the same if there is a password, you will need to type it.
All right, then, list databases with you well know.
And here are the database's.
So now I'm going to create a user first by using the Create User Command great user user for MSF, Pete,
and we're going to enter my very strong password two times.
And now let's create a database by Create DB.
That's the command that is owned by the user for MSF that we just created.
So create DB DB for MSF owner equals user for MSF.
All right.
So let's list the databases.
And sure enough, here I have the database, so I am now finished with PostgreSQL and I'm going to exit.
And I'll open MSF console in quiet mode again.
Hey, it's finally open and let's just quickly check the DB status.
So as you can see here, it connects to the default database.
So now I'm going to disconnect from that database and that's successful.
Now I'm going to connect to my new database, DB for MSF, DV Connect user for MSF.
One, two, three, four, and localhost colon, five, four, three, two, slashed before as one,
two, three, four is my strong password, as you can see.
All right, so now let's check the status of the database.
OK, good.
So here you see that I have connected the new one.
And you can now work within the workspaces, add the lead juice, it's all on you now.