Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question

migrated from Jan 6 '13 at 9:02

This question came from our site for professional and enthusiast programmers.

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:

share|improve this answer
Hey many thanks! I didn't know that this is possible using PgAdmin. I have it installed to administrate my local dev mode database. Unfortunately it is a different version than the server requires, so it denies access to the server. For this reason, and for other reasons, I'd like to use a Web tool for the purpose of editing datasets. Therefore I use phpPgAdmin. But the editing function seems to be missing. – user1625837 Jan 5 '13 at 5:02
My PgAdmin tool doesn't provide an edit function. It begins to dawn on me it might have something to do with the particular table. I suspect the missing primary key is to blame for it... – user1625837 Jan 5 '13 at 5:17
up vote 0 down vote accepted

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);
share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .