WEBVTT

00:07.730 --> 00:11.060
I will call you back again for another lecture on PostgreSQL.

00:11.060 --> 00:17.510
And in this video lecture, I'll go ahead and teach you how to connect to your actual database.

00:17.570 --> 00:18.020
All right.

00:18.020 --> 00:22.160
So we created this database called strains and the previous lecture.

00:22.160 --> 00:27.200
And the let's go ahead and learn how to connect to our database.

00:27.740 --> 00:28.160
All right.

00:28.190 --> 00:31.310
Now we have been able to create a database.

00:31.340 --> 00:34.130
Now we want to connect to the database.

00:34.130 --> 00:38.240
And if want to connect to your database go ahead and use Backward slash.

00:38.240 --> 00:42.020
And now you go ahead and write connect.

00:42.020 --> 00:44.630
And then you give the name of the database.

00:44.630 --> 00:45.980
And here it is student.

00:45.980 --> 00:51.620
And then I'll go ahead and the C students and hit enter.

00:51.620 --> 00:57.860
And it says you are now connected to database student as user PostgreSQL or Postgres.

00:58.280 --> 01:03.290
So you are now connected to database student as user Postgres.

01:03.680 --> 01:06.200
And then I can actually make rates on it as it is.

01:06.350 --> 01:07.760
I am working on this.

01:07.790 --> 01:12.950
If I want to do that, I'll go ahead and put backward slash and another database I have right in here

01:12.950 --> 01:13.790
is moi.

01:13.820 --> 01:19.400
I can go over and say connect and moi.

01:19.490 --> 01:24.380
And it says you are now connected to database moi as user Postgres.

01:25.070 --> 01:32.720
And now I can actually move over to Postgres and connect to that again by entering connect.

01:35.540 --> 01:36.320
Posts.

01:36.560 --> 01:41.210
Chris I hope that is the name that is Postgres.

01:41.210 --> 01:44.720
So I'm going to add an S right in here and hit enter.

01:44.750 --> 01:49.220
I am not connected to database postgres s user Postgres.

01:49.820 --> 01:53.660
Now this is a one way of connecting to your database.

01:53.690 --> 01:55.730
Another way is by using backward slash.

01:55.730 --> 02:02.420
And I'll go ahead and put just see a new space and I can go ahead and connect to a database course to

02:02.420 --> 02:02.870
date.

02:02.870 --> 02:07.960
And if I hit enter you can see you are not connected to the database state as user.

02:07.990 --> 02:09.190
Postgres.

02:09.820 --> 02:17.470
So you can see that it can actually connect to any of your database is in either connect or using C.

02:17.500 --> 02:25.840
So if I go ahead and put C again and say connect to MLA and hit enter, you are now connected to Moi

02:25.870 --> 02:32.350
as user Postgres and the same thing is applicable to Postgres.

02:32.350 --> 02:37.750
And go ahead and hit enter and not connect it to database Postgres as Postgres.

02:37.750 --> 02:43.510
So in that way you can actually connect to a database using either connect or using either C.

02:43.540 --> 02:45.910
So any of this works out fine right.

02:45.940 --> 02:47.530
So go ahead and connect to database.

02:47.530 --> 02:54.490
So can we go to kickstart and then move deep into this PostgreSQL and then learn more on this.

02:54.490 --> 02:57.880
So if you have any question on this use the question and answer section.

02:57.880 --> 03:01.480
Or you go ahead and move over to the next video lecture.