Follow this step-by-step guide to install PostgreSQL ... the primary and foreign keys are marked with key icons. The connections between tables are the foreign key contraints. Open a shell ...