Re: DELETE FROM fails with error - Mailing list pgsql-sql

chris G�nther <guenther@uscreen.de> writes:
> When I try to delete a row from tblshop I get the error that postgres
> can't find the attribute id_shop. My SQL-command looks like follows:

>     DELETE FROM tblshop WHERE tblshop."ID_Shop" = 12

That looks like the correct way of quoting a mixed-case field name.
I think the field is not named quite like you think it is.  Try doing
pg_dump -s -t tblshop databasename

to see what the field names really are.
        regards, tom lane