views:

80

answers:

2

In PHPmyAdmin I can delete rows without using SQL.

Is there a way to do this in PHPpgAdmin ?

+1  A: 

Yes there is, just select the table, click "browse" and then click "delete" (in the column "actions") for every row you want to delete.

Frank Heikens
I don't see column actions. Are you sure you are talking about PHPpgAdmin and not PHPmyAdmin ?
xRobot
Yes I am: http://phppgadmin.kattare.com/phppgadmin4/
Frank Heikens
I see column actions but In my PHPpgAdmin there is NOT a column actions. Maybe is it disabled ? thanks ^_^
xRobot
In some table of your phppgadmin there isn't column actions.
xRobot
+1  A: 

phpPgAdmin (ppa) gives ability to edit/delete a row only when it founds an unique index in the table (or in requested fields for a query) and the value for the indexed col is not null.

Without unique index (or PK), ppa could not determine a WHERE clause to select the only row you want to edit/drop.

pcent
ops... you right. How can I add a PK on my existing table ?
xRobot
ALTER TABLE your_table ADD PRIMARY KEY (your_id_field1);Be aware that the key fields must not be null...
pcent
I've just seen your other question about PK, there's a more complete answer
pcent