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 - 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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
Connect to a PostgreSQL server7m 11s
-
(Locked)
Create a database3m 20s
-
Execute SQL commands7m 1s
-
(Locked)
Backslash (meta) commands4m 6s
-
(Locked)
Get help with SQL command keywords5m 36s
-
(Locked)
Execute commands from a file2m 43s
-
(Locked)
List database contents7m 39s
-
(Locked)
Describe object configuration2m 29s
-
(Locked)
Challenge: Obtain database information1m 14s
-
(Locked)
Solution: Obtain database information4m 52s
-
-
-
-
-