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?
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.
Hope that make sense, and please be patient with me.
Cheers,
Zery