Re: DELETE FROM fails

Поиск
Список
Период
Сортировка
От Manuel Sugawara
Тема Re: DELETE FROM fails
Дата
Msg-id m3itkrku6e.fsf@dep1.fciencias.unam.mx
обсуждение исходный текст
Ответ на DELETE FROM fails  (chris Günther <guenther@uscreen.de>)
Список pgsql-novice
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.

В списке pgsql-novice по дате отправления: