Re: [HACKERS] How to hidde the column from the user
On Tue, 1 May 2007, 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. Let user work with view public.table_view, which is a view of backend.table. Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(495)939-16-83, +007(495)939-23-83 ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [HACKERS] How to hidde the column from the user
On Tue, May 01, 2007 at 03:09:17PM +0530, 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. Make it a view on a real table and revoke access permissions on the real table? Have a nice day, -- Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to > litigate. signature.asc Description: Digital signature
Re: [HACKERS] How to hidde the column from the user
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
