chris Günther <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
