LevelUp 6: Can look up and use basic psql commands

gistfile1.txt

1. Demonstrate the Rails command to enter the psql shell.

rails dbconsole

2. Demonstrate the command to get help on other psql commands.

psql --help for general help on psql.

From within psql, you can use \? to get the help on psql internal commands or \help for SQL commands.

3. Use that command to find out how to list all views, and then to view the query that generated a view.

- To list all views: \dv
- To view the query that generated a view: select view_definition from information_schema.views;