PhpPgAdmin: Edit contents

Question

How can I edit the contents of a table in phpPgAdmin without using SQL? Or is there an alternative tool that allows me to edit datasets?

Answer 1

I've used pgadmin3 on ubuntu to work with a postgres database. It allows you to modify rows without using sql. I'm assuming phpPgAdmin is similar (but I haven't used it). I edit rows in pgadmin3 by:

1. right click table name
2. view data
3. click on the cell I want to change to edit

Here is the site for pgadmin: http://www.pgadmin.org/

Answer 2

Add a primary key, then you may edit a table's contents. This is possible on an existing table filled with contents using

ALTER TABLE table_name ADD PRIMARY KEY (column_name);