rupesh bajaj wrote:
Hi,
I want to add a column in the table and also want to hidde that column from
the user. So that user's normal insertion and update goes on (means user
will not supply the value for my hidden column). Is there any way to hidde
the column from the user. I tried to make my column (attisdropped
setting as
true). So now that column is hide from the user but now that column will be
sometime deleted by postgres. But i do not want that my column should be
deleted. Is there any way for doing this. Or can you suggest some better
way
for this.
You should ask usage questions on pgsql-general to get more informative
responses.
Create a view on top of the table that hides the column.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org