Re: DELETE FROM fails

chris Günther <guenther@uscreen.de> writes:

> Please, can anyone help me out? It is really anoying when you can't delete datasets
> especially because my application is already online (I use postgres with PHP) and
> there are 20 tables with alltogether 120 MB of data in it

try to figure out exactly how postgres thinks that columns are named,
use pg_dump program as

$ pg_dump -s -t <table-name-goes-here>

Then use the names as they are dumped

HTH,
Manuel.