Would you like to inspect the original subtitles? These are the user uploaded subtitles that are being translated:
1
00:00:01,430 --> 00:00:10,340
Hey, it's Mo back again, and I'm here to quickly explain how to set up your environment on Windows
2
00:00:10,340 --> 00:00:18,710
to allow for quick and easy access to the actual command on Windows, because in our initial set videos,
3
00:00:18,710 --> 00:00:22,750
we were referencing these bin files directly.
4
00:00:23,150 --> 00:00:30,290
Now, if we were to say want to use command line as our main source of interacting with PostgreSQL,
5
00:00:30,620 --> 00:00:32,360
we don't really want to do that.
6
00:00:32,360 --> 00:00:32,700
Right.
7
00:00:33,080 --> 00:00:38,840
So this video is here to show you quickly and easily how to set up Posterous in such a way that you
8
00:00:38,840 --> 00:00:44,120
can use the Piscatella command and all of these commands easily from your command prompt, no muss,
9
00:00:44,120 --> 00:00:44,830
no fuss.
10
00:00:45,320 --> 00:00:50,750
So if you go down here to start and you look for environment variables, you can see that we'll have
11
00:00:50,750 --> 00:00:53,630
this little option here, edit the system, environment variables.
12
00:00:53,870 --> 00:01:00,290
And if we open that up here at the bottom, what you'll find is we'll have a environment variables button
13
00:01:00,590 --> 00:01:07,460
when we click that what we'll see is that you have user variables in this case for education, which
14
00:01:07,460 --> 00:01:10,340
is my user, and you'll have system variables.
15
00:01:11,310 --> 00:01:16,530
Now we want to zoom in on the system variables, and we specifically want to zoom in on the path variable,
16
00:01:16,530 --> 00:01:22,200
because what the path variable is, is it is the variable that is going to be loaded by command line
17
00:01:22,680 --> 00:01:28,890
and subsequently power shell and any other command prompt that you may install or want to use.
18
00:01:29,430 --> 00:01:35,010
But the path variable is basically a variable that in essence will point to all the binaries, all the
19
00:01:35,010 --> 00:01:39,630
executables, the software basically that allows you to run certain commands.
20
00:01:39,780 --> 00:01:46,230
And so if we open up the path variable, what we can see is that you have multiple different options
21
00:01:46,230 --> 00:01:46,800
in here.
22
00:01:46,920 --> 00:01:52,860
We have a system 32, which is pointing to all of the regular commands that we can run in Windows and
23
00:01:52,890 --> 00:01:54,420
all of these other ones.
24
00:01:54,690 --> 00:01:56,400
But we want to zoom in on.
25
00:01:56,970 --> 00:02:03,810
And the most important one is that to the path variable, we add the PostgreSQL bin folder and the Postgres
26
00:02:03,810 --> 00:02:06,210
bin folder bin stands for Binary in.
27
00:02:06,210 --> 00:02:12,630
It adds all of these commands that we can KPG dump, rewind, rewire, all of these different commands
28
00:02:12,630 --> 00:02:14,850
are going to be able to be used.
29
00:02:15,150 --> 00:02:18,670
And one of the most important ones that we want to use is this one.
30
00:02:18,810 --> 00:02:24,000
Now, when we install software, basically what we're doing is we're installing what quote unquote binaries.
31
00:02:24,000 --> 00:02:28,230
And these binaries are would allow us to run certain things.
32
00:02:28,230 --> 00:02:33,810
And in this case, this binary cable is the main command that we use to connect to the postgresql world
33
00:02:33,810 --> 00:02:34,890
from the command prompt.
34
00:02:35,640 --> 00:02:41,010
And when we add the Benfold or the entirety of the bin folder to our path, what we're seeing is, hey,
35
00:02:41,010 --> 00:02:47,580
command prompt, go and actually use this folder and load in all of these binaries for me so that I
36
00:02:47,580 --> 00:02:53,100
can run these commands inside of the system so that I don't have to reference them directly from where
37
00:02:53,100 --> 00:02:53,520
they're at.
38
00:02:53,520 --> 00:02:55,380
You're going to know about them forever.
39
00:02:55,590 --> 00:02:58,050
And by adding this and pressing, OK.
40
00:02:59,180 --> 00:03:04,310
What we can now do and if you already had power, our command line open, what you're going to want
41
00:03:04,310 --> 00:03:06,230
to do is you're going to want to restart it.
42
00:03:07,130 --> 00:03:11,490
Power Shell is by far the best tool that you can use.
43
00:03:11,750 --> 00:03:13,730
I would steer away from command and command lines.
44
00:03:13,730 --> 00:03:19,260
Great for basic usage, but power Shell just has more features and is better overall.
45
00:03:19,280 --> 00:03:23,360
So if we open Power Shell, what we can see is that if we run the actual command now.
46
00:03:24,250 --> 00:03:27,660
It's going to try to log into my default user, but that's not what I want to do.
47
00:03:27,670 --> 00:03:31,960
I want to do well minus you and I want to log into the Posterous user.
48
00:03:32,080 --> 00:03:36,100
And now it's going to ask me for my password, which during set up, we set the posterous.
49
00:03:37,200 --> 00:03:42,960
If I do come info, what I'll see is that I'm connected to the Postgres database.
50
00:03:43,300 --> 00:03:46,380
Now let's go ahead and verify that we can run some of the commands.
51
00:03:46,380 --> 00:03:47,490
So let's create a table.
52
00:03:47,500 --> 00:03:49,050
Let's do create a table.
53
00:03:49,650 --> 00:03:51,600
And let's say it's a test table.
54
00:03:52,960 --> 00:04:00,700
And let's quickly run that what we can see that we've created the table, so if we run D.T., where
55
00:04:00,700 --> 00:04:02,320
we can see is that we have a test table.
56
00:04:03,010 --> 00:04:08,500
So we have the ability now to run all of the commands and log in to PostgreSQL.
57
00:04:08,860 --> 00:04:13,450
Now, I would recommend using Power Shell, because it's a more fully fledged command line, is easier
58
00:04:13,450 --> 00:04:14,050
to use.
59
00:04:14,350 --> 00:04:18,910
The old command line is kind of limited and a bit different.
60
00:04:19,330 --> 00:04:25,660
But yeah, with all of this, we've set up our environments in Windows to be able to access command
61
00:04:25,660 --> 00:04:26,500
line effectively.
6491
Can't find what you're looking for?
Get subtitles in any language from opensubtitles.com, and translate them here.