From the course: PostgreSQL: Client Applications
Join today to access over 24,700 courses taught by industry experts.
Change the prompt style - PostgreSQL Tutorial
From the course: PostgreSQL: Client Applications
Change the prompt style
- [Instructor] The Psql prompt can give you a good amount of information about your connection. By default, the prompt displays the current database that you're connected to. The equal sign indicates that it's ready for a new command. This will get replaced with a hyphen if you're continuing a command onto multiple lines or an open parentheses, double quote, or a single quote if you have unclosed characters and you've moved on to a new line. It will also display an asterisk if you're inside of a transaction block. And finally we see a pound or a hash symbol, if your user is a super user account. If we switch our connection to the user, Micah we'll see that that changes. I'll use the backslash C meta command and switch into the two_trees database and use the Micah user account. And you'll notice that the prompt suddenly changes to include this greater than symbol instead of the hash symbol. If we switched back to the Postgres user account, you'll see it switches back to the pound…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.