O'Reilly logo

Effective Amazon Machine Learning by Alexis Perrier

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Connecting through the command line

Psql is a command line program that acts as the primary front-end to a Postgresql database. It provides a number of shell commands (pg_dump to dump the content of a database, createdb to create a database, and many others). It also has a number of meta commands to list elements and display information (see the Psql cheatsheet information box). 

Psql cheatsheet: q: Quit/Exit d __table__: Show table definition, including triggers dt : List tables df: List functions dv: List views x: Pretty-format query results instead of the not-so-useful ASCII tables connect __database__: Connect to a database l: List databases Adding a + on a d command will show more results: compare, for instance, d titanic with d+ titanic ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required