How To Configure PgAdmin To Run SQL Queries

Here we will be using Parch And Posey Database

1. Download and install pgAdmin on your computer.

2. Open pgAdmin and connect to your PostgreSQL server by providing the necessary credentials (e.g. host, port, username, and password).

3. Once connected, you should see the server listed under the "Servers" tree in the sidebar.

4. Create a new database in pgAdmin by right-clicking on the server, selecting "New" and then "Database".

5. Open the pgAdmin Query Tool by right-clicking on the server and selecting "Query Tool".

6. Copy and paste the SQL queries for creating the "Porch" and "Post" tables into the editor

7. After the database is created, you can expand it and see the tables, views, and other objects within it.

8. To run an SQL query, right-click on the database and select "Query Tool".

9. Type your query in the editor and press the execute button or use the shortcut key (F5) to run the query.

10. The results of the query will be displayed in the tab below the editor.