From the course: Introduction to PostgreSQL
Join today to access over 25,300 courses taught by industry experts.
Connecting via CLI - PostgreSQL Tutorial
From the course: Introduction to PostgreSQL
Connecting via CLI
- [Instructor] So once you're able to access a Postgres installation, how do you actually interface with it? The typical place you would get started is using the default command line interface that comes with Postgres called psql. Because it's installed with Postgres, no additional setup is required to work with it. Psql is fully featured and there are many cheat sheets available online to learn about flags and commands that make it easy to use. Input can be passed to the database server from files or command line arguments. In either form, you can interact with the database server using this input, either from the host operating system or directly within the server. Okay, so let's first make sure that psql is actually up and running. We'll do this by checking the version that's installed. If it's not running, we'll receive an error. Great, so we can see everything is working as expected. Let's create an example…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.