On 26/02/2011 15:04, Zery wrote:
Hi, I'm new in database world, but I know postgres for a long time ago. Now I'm trying to focusing on developing a database using postgresql and postgis extension. I have several question that needs help from all of you. 1. I understand about a view, the lack for me is I cannot edit a view table, is it possible to create a view on top of a table, so I can view the table by joining to another table but I can edit the table also?
You can't edit views in PostgreSQL - they are read-only. You can get a similar effect using rules, but I gather they can be difficult to get right - I've never tried it myself.
What exactly are you trying to do? From the above, it sounds a bit as if you might be restricting access to a table; if that's the case, you can do it better using permissions. Views, in my experience, are more often used for simplifying complex queries (among other things). If you tell us more about what you want to do, it will help people to come up with suggestions.
2. Can i categorized tables by its category? so when I open the database using my database client I will see "a folder inside a folder" like view, not all the tables listed in my database client, but the category will be listed, and when I open the category then I see the tables.
No, there's no concept of a table category in PostgreSQL. Perhaps schemas may do what you want? - They effectively give you databases within databases.... though they group together many other types of objects - views, functions, types, etc etc - not just tables. Again, what exactly are you trying to do?
Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@xxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
