Pinnacle : Database

DETAILS

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’;