PostgreSQL TutorialLesson 4Free preview

PostgreSQL Get Started

This lesson is part of PostgreSQL · All levels

Summary

Get Started page guides your first step: create a database, connect to it, then create a table and enter the data. This thread becomes a basic pattern that is used repeatedly when working with PostgreSQL. Once you get used to it, you can move on to selection queries and data editing.

Key points

Create a new database with the CREATE DATABASE or createdb command.
Use the psql to connect to the database, then create a table with CREATE TABLE.
Enter sample data through INSERT INTO so that it can be practiced immediately.
Run SELECT to make sure the data is stored correctly.

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.