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