Connecting with psql

psql is the PostgreSQL interactive terminal client, a command-line based interface to PostgreSQL databases. Although many users will deem psql to be the most rudimentary interface, it is a terrific way to browse the Unison schema and experiment with queries rapidly. psql is part of the PostgreSQL distribution; binaries and source code are available from http://www.postgresql.org/.

Unison is available to the public at host unison-db.org, database unison, as user PUBLIC. No password is required. (The default PostgreSQL port, 5432, is used and is not typically required.) A typical session looks like this:

eg$ psql -h unison-db.org -U PUBLIC -d unison
Welcome to psql 8.0.3, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

unison=>

From now on, I'll use assume you're already connected to Unison and will use unison=> as the prompt.