Overview
-
Learn about the PostgreSQL command line utilities that provide database administrators with a powerful set of tools for managing remote database servers.
Syllabus
-
Introduction
- Work with PostgreSQL on the command line
- What you should know
- Use the exercise files
- What are PostgreSQL client applications?
- Locate client applications on Windows
- Locate client applications on macOS
- Set environment variables on Windows
- Set path on macOS
- Create a PostgreSQL server
- Connect to a PostgreSQL server
- Create a database
- Execute SQL commands
- Backslash (meta) commands
- Get help with SQL command keywords
- Execute commands from a file
- List database contents
- Describe object configuration
- Challenge: Obtain database information
- Solution: Obtain database information
- Streamline password submission
- Change the prompt style
- Save custom environment settings
- Input queries from the command line
- Format aligned text output
- Output results to external files
- Save query results to .csv
- Output HTML and LaTeX tables
- Export files from the command line
- Challenge: Export a data table
- Solution: Export a data table
- Create backups with pg_dump
- Configure backup options
- Data-only and schema-only backups
- Create a backup of a single table
- Restoring plain-text backups
- Custom archive backup files
- Restoring database archives with pg_restore
- Partial database restores
- Next steps
