Login info:

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


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

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License