The PostgreSQL Command-Line Client

You invoke the PostgreSQL command-line client with the command psql. Like mysql, you can invoke psql with the name of the database to which you would like to connect. Also like mysql, psql can take several options. These options are listed in Table 27.2.

Table 27.2. Command-Line Options to Use When Invoking psql

Image

Several more options are available in addition to those listed in Table 27.2. See the psql man page for details on all the available options.

Get Ubuntu Unleashed 2013 Edition: Covering 12.10 and 13.04, Eighth Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.