PostgreSQL Fundamentals: SQL Command Line

Intended Audience

This course is intended for:

• Database administrators
• Database developers
• Database architects
• Database engineers

Course Objectives

In this course, you will learn how to:

• Use psql - The native, command-line client to postgresql

Prerequisites

We recommend that attendees of this course have the following prerequisites:

• Taken the PostgreSQL Fundamentals course
• Familiarity with relational databases

Delivery Method

This course is delivered through:

• Digital training

Duration

15 minutes

Course Outline

This course covers the following concepts:

• psql client
• Create a test table
• List All Tables
• Describe Tables
• Make a CSV
• Expanded Output Mode
• SET Parameters
• psqlrc File
• Prompts
• Watching Queries
• Using in Scripts