How to run SQL against a pgAdmin database

Follow the instructions below to run SQL directly against a pgAdmin database.

Step-by-step guide

  1. In the object browser on the left, double-click on PostgesSQL x.x, double-click on Databases, and double-click on esp_mdphnet
  2. In the taskbar at the top of the screen, click the SQL button
  3. A new Query window will open. Enter the SQL code in the upper pane.
  4. Click the green triangle (Execute Query) to run the query. The results will appear in the lower pane.