Column named parent in postgresql

Does postgresql allow columns named "parent"?

Neither

SELECT id, parent, name FROM address WHERE id=1

nor

SELECT id, "parent", name FROM address WHERE id=开发者_运维知识库1

give me an actual result. Instead I get:

ERROR:  column "parent" does not exist
LINE 1: SELECT id, "parent", name FROM address WHERE id=1
                   ^
In statement:
SELECT id, "parent", name FROM address WHERE id=1

The table very certainly has a column called parent.

---

The word "parent" does not appear to be a keyword in postgresql so something else is the issue.

When you surround the column name with double-quotes, the column name becomes case sensitive. Can you post the output of "\d address"? This would be helpful in diagnosing the issue.

---

It was actually quite insidious. There was nothing wrong with anything. The whole issue was the APC cache holding onto something it shouldn't have. Sorry about the confusion.