From the course: PostgreSQL Essential Training
Unlock the full course today
Join today to access over 24,400 courses taught by industry experts.
Connect to the server with psql - PostgreSQL Tutorial
From the course: PostgreSQL Essential Training
Connect to the server with psql
- [Instructor] The Psql client is a command line interface for working with Postgres database servers. It provides a quick way for administrators to log into the server and run commands, but it's not the most user-friendly environment for new users since it requires that you know what commands you want to run and how to type them out. However, I do think that it's important to see briefly to help reinforce the idea that the client application is completely separate from the database server, and that you have your choice of the client that you use depending on the ways that you prefer to work. The Psql application is a very important tool in the world of Postgres development. Now, if you've installed PostgreSQL in the traditional way on your Mac or PC, then you'll find a link to the Psql application in your applications folders. Here on Windows, I've already pinned it to the start menu. Otherwise, scroll down into your folders…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
What is PostgreSQL?4m 59s
-
(Locked)
Download and install PostgreSQL7m
-
(Locked)
Install PostgreSQL with Docker5m 34s
-
(Locked)
Connect to the server with psql8m 4s
-
(Locked)
Browse the server with a graphical interface5m 19s
-
(Locked)
Connect pgAdmin to Docker4m 35s
-
(Locked)
Tour the pgAdmin interface4m 48s
-
(Locked)
Use pgAdmin’s toolset5m 31s
-
(Locked)
Create objects with pgAdmin's dialog workflows5m 56s
-
-
-
-
-
-
-