From the course: PostgreSQL: Client Applications
Unlock the full course today
Join today to access over 24,700 courses taught by industry experts.
Solution: Obtain database information - PostgreSQL Tutorial
From the course: PostgreSQL: Client Applications
Solution: Obtain database information
(upbeat music) - [Instructor] I hope you are able to apply some of your knowledge about the PSQL interactive terminal to answer my challenge questions. Let's walk through each step to find the answers together. Now, the first question was to locate the website URL for the drop index command. We can get that by querying the help documentation with the backslash H meta command or you can use backslash help either one will do the same thing. Now, if I just run backslash help it's just going to show me all of the different commands that we can find help on so that's not going to be helpful but what I can do is type in backslash help and the specific command that we were interested in which was drop index. Alright, that runs it tells me the syntax where the drop index command but what I'm interested in here is the URL so there's the URL for the documentation for the drop index command and that's the answer to the first question. The second question asked us to identify the system user…
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
-
-
-
-
-