PHPpgAdmin: How delete rows without using SQL

Question

In phpMyAdmin I can delete rows without using SQL.

Is there a way to do this in phpPgAdmin ?

score 5 · Accepted Answer · answered May 31 '10 at 14:01

5

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.

answered May 31 '10 at 14:01

pcent

1,929
2
14
17

ALTER TABLE your_table ADD PRIMARY KEY (your_id_field1); Be aware that the key fields must not be null... – pcent May 31 '10 at 16:52
I've just seen your other question about PK, there's a more complete answer – pcent May 31 '10 at 17:01

score 2 · Answer 2 · answered May 31 '10 at 11:30

2

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

answered May 31 '10 at 11:30

Frank Heikens

117,544
24
142
135

1

I don't see column actions. Are you sure you are talking about PHPpgAdmin and not PHPmyAdmin ? – xRobot May 31 '10 at 11:58
1

I see column actions but In my PHPpgAdmin there is NOT a column actions. Maybe is it disabled ? thanks ^_^ – xRobot May 31 '10 at 12:14
In some table of your phppgadmin there isn't column actions. – xRobot May 31 '10 at 12:17
@FrankHeikens When there is no PK or Unique index then you don't see actions column. – jPO Apr 24 '15 at 11:33

PHPpgAdmin: How delete rows without using SQL

2 Answers2

Linked