Work with PostgreSQL on the command line - PostgreSQL Tutorial

- [Adam] The PostgreSQL database platform is a secure, stable, and highly performant system that's popular across a wide variety of industries and applications. While the standard graphical user interface, pgAdmin is a highly capable tool, for the ultimate performance of flexibility it's worth getting to know the native command line tools as well. These tests interface utilities, or client applications, provide fast efficient access to some of the most common tasks that you'll perform on a Postgres server. From querying the database to exporting data and creating database backups, these utility applications can do it all. Hi, my name is Adam Wilbert and I've been helping people work efficiently with their databases for over a decade. In this course, we'll dive into the many configurable options that make these client applications a powerful addition to your data science toolbox, and I'll demonstrate techniques that are perfect for incorporating into scripts and creating automated workflows. There's a lot to cover, so let's get started.