chris Gnther <guenther(at)uscreen(dot)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