Database

• The Pinnacle database runs on PostgreSQL

Login info:

* Username: postgres
* Password: postgres
* DB: clinical

Examples

Use another computer with PSQL installed to connect to Pinnacle's database.

Connection String

/usr/postgres/8.3-community/bin/psql -d Clinical -U postgres -p postgres -h PinnacleServerHostName

Useful PSQL commands

\o /path/to/output/file
\d - List all tables
\d tablename = Display all fields in a table
\q = quit

Sample SQL command

SELECT institutionid,firstname,lastname FROM patient WHERE institutionid=’1’;