Spaces
Teams
Apps
Templates
Create
Archive - Help and Support
All content
Space settings
Shortcuts
Troubleshooting Articles
Troubleshooting Articles
This trigger is hidden
How-to articles
How-to articles
This trigger is hidden
Content
PopMedNet™ Overview
DataMart Client
•
"Network is Offline" message in the DataMart Client
•
Archive - Data Mismatch Error When Executing a Summary Table Query in the DataMart Client
•
DataMart Client crashes frequently
•
DataMart Client is not displaying all request in the request list
•
How to add a new network to an existing DataMart Client
•
How to download a sample Mini-Sentinel Summary Table database
•
How to run SQL against a pgAdmin database
•
How to run two DataMart Client versions side-by-side
•
How to view data in pgAdmin
•
Installation Guide for Testing ESP: MDPHnet
•
Invalid Data Set: Root Element is Missing error
•
Microsoft Access Driver is not an option in the ODBC Administrator Tool
•
Model Processor errors
•
Problems with Microsoft Office after installing the DataMart Client
•
Requests are taking longer than expected to execute
•
Requests fail when the DataMart is set to run automatically
•
Service URL error message
•
The Run button on the DataMart Client is grayed out
•
Unable to login to the DataMart Client
•
What to do when upgrading or switching computers
Portal and Investigators
Troubleshooting Articles
•
How-to articles
Apps
Gliffy Diagram
Archive - Help and Support
DataMart Client
How to run SQL against a pgAdmin database
How to run SQL against a pgAdmin database
Alison Leibowitz (Unlicensed)
Melanie Davies (Unlicensed)
Owned by
Alison Leibowitz (Unlicensed)
Last updated:
Jan 03, 2014
by
Melanie Davies (Unlicensed)
1 min read
Loading data...
Follow the instructions below to run SQL directly against a pgAdmin database.
Step-by-step guide
In the object browser on the left, double-click on PostgesSQL x.x, double-click on Databases, and double-click on esp_mdphnet
In the taskbar at the top of the screen, click the SQL button
A new Query window will open. Enter the SQL code in the upper pane.
Click the green triangle (Execute Query) to run the query. The results will appear in the lower pane.
Related articles
Page:
Installation Guide for Testing ESP: MDPHnet
Page:
How to view data in pgAdmin
Page:
How to run SQL against a pgAdmin database
{"serverDuration": 23, "requestCorrelationId": "20707512bd4d4f4982989098c738217e"}