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

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…

Contents