From the course: PostgreSQL: Client Applications

Unlock the full course today

Join today to access over 24,700 courses taught by industry experts.

Challenge: Obtain database information

Challenge: Obtain database information - PostgreSQL Tutorial

From the course: PostgreSQL: Client Applications

Challenge: Obtain database information

- [Narrator] We've seen a number of techniques that you can use in the Psql client application to explore a PostgreSQL database. Let's apply what you've learned to answer some questions about the Twotree's database and our Postgres server. First, I'd like to know the webpage where you'll find the documentation for the Drop Index command. Next, identify the system user account that has the most number of memberships. Then I want to know what the /a meta-command does. We didn't cover this command, but we will in a few chapters. You can get a head start by finding it in the internal help documentation. As a hint, this one is in the formatting group. Finally, let's dive into the Twotrees database. What is the data type of the product name column in the inventory.products table. And finally, the sales.orders table has a foreign-key constraint that references what table. This challenge should take you about five minutes to complete. In the next movie, I'll show you how I'd find the answers…

Contents