Editing records in a database

Webmin allows you to quickly edit data in your PostgreSQL database through a simple interface. In this recipe, we will demonstrate how to add, edit, and delete records in a database table.

Getting ready

In this recipe, we will use examples based on the testdb database and people table created in the recipe, Editing the structure of your database.

How to do it...

We'll add a record to the people table of the testdb database; we'll edit the same record, and finally delete it to show how to perform these actions in Webmin.

Perform the following steps to add a row to a database table:

1. Navigate to Servers | PostgreSQL Database Server.

2. Click the icon that represents the testdb database.

3. Click the icon that represents the people table.

4. Click the View Data button.

5. Click the Add row button.

6. Fill in a numeric id and type in a name in the text box.

7. Click the Save button.

Perform the following steps to edit a row:

1. Navigate to Servers | PostgreSQL Database Server.

2. Click the icon that represents...