I'm still quite new to postgres, struggeling with 'views'... I'm on
OS X, using aquadatastudio to interface the db.
Now, after issuing a 'CREATE VIEW' command, I get back a '1 record
affected' message, and I can use the view. However, the view doesn't
appear in the tree view of aquadatastudio (even after reconnecting),
and after restarting postgresql, it's lost. I used to think that
'CREATE VIEW...' is all I have to do, am I wrong?
TIA,
Christoph