Skip to content
Postman API Testing Tips

How To Use Postman To Update Database Pgadmin

API Testing Blog

Using Postman to Update a Database in pgAdmin

Postman is a powerful tool for testing and interacting with APIs, including those that interact with databases like PostgreSQL. While Postman doesn’t directly update the database itself, it can be used to send requests to an API endpoint that handles database updates. This guide will walk you through the process of using Postman to update data in a PostgreSQL database using a custom API.

Step 1: Creating the API Endpoint

First, you need to create an API endpoint that handles the update request. This requires setting up a backend server (e.g., Node.js, Python, Java) that communicates with the PostgreSQL database.

Here’s a simple Node.js example using the pg library:

const express = require('express');
const pg = require('pg');


const app = express();
const port = 3000;


const pool = new pg.Pool({
  user: 'your_username',
  host: 'localhost',
  database: 'your_database',
  password: 'your_password',
  port: 5432,
});


app.put('/users/:id', async (req, res) => {
  const { id } = req.params;
  const { name, email } = req.body;


  try {
    const result = await pool.query(
      'UPDATE users SET name = $1, email = $2 WHERE id = $3',
      [name, email, id]
    );


    res.json({ message: 'User updated successfully', data: result.rows });
  } catch (error) {
    console.error(error);
    res.status(500).json({ error: 'Failed to update user' });
  }
});


app.listen(port, () => {
  console.log(`Server listening on port ${port}`);
});

This example defines a PUT endpoint that updates a user record with the given ID. The req.body contains the new name and email for the user. The code uses prepared statements to handle SQL injection vulnerabilities.

Step 2: Setting Up Your Postman Request

Open Postman and create a new request.

  1. Select HTTP Method: Choose PUT as we are updating data.

  2. Set the URL: Enter the URL of your API endpoint, e.g., http://localhost:3000/users/1.

  3. Add Headers:

    • You may need to include headers like Content-Type: application/json for sending JSON data.

Step 3: Defining the Request Body

The body of your request contains the updated information for the database record.

  1. Choose Body Type: Select raw and choose JSON as the data format.

  2. Format Data: Enter the updated data as JSON. For example:

{
  "name": "Updated Name",
  "email": "updated.email@example.com"
}

Step 4: Sending the Request

  1. Click Send: This sends the request to your API endpoint.

  2. Review Response: Postman displays the response from the server. Check the status code (ideally 200 for success), and review the response body. It should include information about the updated record.

Step 5: Using pgAdmin to Verify Updates

  1. Open pgAdmin: Access your PostgreSQL database through pgAdmin.

  2. Navigate to the Table: Locate the table you updated (e.g., “users” in our example).

  3. Verify the Changes: Examine the data in the table to confirm that the changes you sent via Postman have been successfully applied.

Example: Updating a Specific User

Request:

  • Method: PUT
  • URL: http://localhost:3000/users/1
  • Headers: Content-Type: application/json
  • Body:
{
  "name": "Updated Name",
  "email": "updated.email@example.com"
}

Response (Status Code 200 OK):

{
  "message": "User updated successfully",
  "data": [
    {
      "id": 1,
      "name": "Updated Name",
      "email": "updated.email@example.com"
    }
  ]
}

Security Considerations

Always remember to implement appropriate security measures for your API endpoints:

  • Validate Inputs: Ensure your API validates all input data to prevent SQL injection and other vulnerabilities.
  • Authentication: Integrate authentication and authorization to restrict access to specific users or roles.
  • Rate Limiting: Limit the number of requests per user or API key to prevent abuse.
  • Encryption: Consider using HTTPS to secure communication between your API and clients.

Further Enhancements with Postman

You can further streamline your workflow by utilizing Postman’s features:

  • Collections: Organize all your API requests into collections for better management and reusability.
  • Environments: Create different environments (e.g., development, testing, production) to manage API endpoints and variables across different environments.
  • Tests: Write automated tests in Postman to verify the response status codes, data content, and other aspects of your API’s behavior.

By mastering these techniques and utilizing Postman’s features efficiently, you can significantly improve the efficiency and reliability of testing your API endpoints and interactions with your PostgreSQL database.

API Testing Blog