I created a screencast to showcase some of the basic features of pgcli.

pgcli is a client for postgres that can do autocompletion and syntax highlighting.

This video covers:

• Installation
• Launching pgcli
• Switching databases
• Basic auto-completion for SELECT, CREATE, INSERT and JOIN statements.
• Expanded output
• Multi-line mode

Video:

If there is enough interest, I'll produce a few more screencasts of other features available in pgcli. Please reach me via twitter or email to provide feedback.

I'm also working on a new project called mysql-cli. I've launched a kickstarter campaign for that project and I'd like your support. Please forward the project to your friends and coworkers.