| From: | Manuel Sugawara <masm(at)fciencias(dot)unam(dot)mx> |
|---|---|
| To: | chris Günther <guenther(at)uscreen(dot)de> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: DELETE FROM fails |
| Date: | 2001-03-30 18:06:49 |
| Message-ID: | m3itkrku6e.fsf@dep1.fciencias.unam.mx |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
chris Günther <guenther(at)uscreen(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | ADBAAMD | 2001-03-30 18:27:42 | Re: Help on Postgres and locale - norwegian characters are not possible in my SuSE 7.0 stock install |
| Previous Message | José Luiz | 2001-03-30 15:32:13 | Re: Error in the starting of Postgresql |