Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
add comment

migrated from stackoverflow.com Jan 6 '13 at 9:02

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

2 Answers

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/

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
add comment
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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.